Deletes rows from a global or central table.
Available in a network database and requires the star$modify role.
Parameters:
| Name | Optional | Type | Description |
| table$ | Mandatory | Text | The name of the table to delete rows from. |
| where$ | Mandatory | Text | The logical expression to identify the rows to be deleted. |
Examples:
SELECT delete_rows('mytable','col=1'); -- deletes rows from 'mytable' where col=1
Tips:
- The star$tables view lists existing tables and their scope
Comments
Article is closed for comments.