DELETE

This statement deletes specified rows from a database table.

Syntax

DELETE FROM table-name [ alias-name ] 
[ WHERE search-condition ] 

Remarks

INSERT, UPDATE, and DELETE statements behave in an atomic manner. That is, if an insert, update, or delete of more than one row fails, then all insertions, updates, or deletes of previous rows by the same statement are rolled back.

Examples

The following statements deletes the row for first name Ellen from the person table in the sample database.

DELETE FROM person where First_Name = 'Ellen' 

The following statement deletes the row for Modern European History (HIS 305) from the course table in the sample database:

DELETE FROM Course WHERE Name = 'HIS 305'