Truncates (removes all rows) a global or central table.
Available in a network database and requires the star$modify role.
Parameters:
| Name | Optional | Type | Description |
| table$ | Mandatory | Text | Name of table to be truncated. |
Examples:
SELECT truncate_table('mytable'); -- truncates table 'mytable';
Tips:
- The star$tables views lists existing tables and their scope
Comments
Article is closed for comments.