Data rows can be deleted from a table using Delete placed inside embedded SQL brackets.
Example:
IMPORT orders = a1.orders
{DELETE FROM orders WHERE employeeid = 2}
Note: The Delete command does not work with data that has been created using the CREATE TABLE
command if that table has not yet been Columnized.
Comments
Please sign in to leave a comment.