delete_rows

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
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk