Deleting rows from a table
You can type an SQL DELETE statement on the SQL Query panel to delete one or more rows from a table.
For example, the following statement deletes the row for employee number 410 from the MYSTAFF table:
DELETE FROM MYSTAFF WHERE ID = 410
This statement deletes all rows that are associated with Department 38:
DELETE FROM MYSTAFF WHERE DEPT = 38