4.2.4 The DELETE statement

Deletes one or more tuples in a table according to given conditions

General form:

DELETE FROM

[ WHERE ];

Sample DELETE statements from the Case Example

Query 40: Deletes Customer record with Customer Number 004

DELETE FROM customers

WHERE cust# = 004;

DELETE FROM Ord_Items; <-------------------

Deletes all rows in Ord_Items Table. The table remains empty after the DELETE operation.