Purges old data from a local table.
The function guarantees to keep data inserted at or after the specified timestamp and attempts to delete as much data as possible inserted prior to the specified timestamp to reclaim as much storage space as possible. Note that there is no guarantee about how much data will be deleted.
Available in a network database and requires the star$modify role.
|table$||Mandatory||Text||The name of the local table to be purged|
|datetime$||Mandatory||Timestamp||The insert timestamp threshold|
SELECT purge_table('mytable','2017-01-01'); -- reclaims space from data inserted prior to Jan 2017
- The star$tables view lists existing tables and their scope