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.
Overview
Content Tools