Delete Query (SQL)

The DELETE command removes tuples from a relation, it includes a WHERE clause to select the tuples to be deleted. Referential integrity should be enforced.

DELETE FROM <table>
WHERE       <condition>

Typically:

• Tuples are deleted from only one table at a time unless CASCADE is specified on an integrity constraint.
• A missing WHERE clause will delete all tuples.
• The number of tuples deleted depends on the number of tuples that satisfy the clause.