Deleting Rows

To delete a row, issue the DELETE statement.

The following example deletes all the rows from the table customer for names that start with the letter "S."

Command> DELETE FROM customer WHERE cust_name LIKE 'S%';