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