DELETE

Use this statement to delete data from an existing table. Its syntax is:

  DELETE FROM table [WHERE wherepredicate]

The parts of this statement have the following meaning:

Part Meaning

table The table from which the data is to be deleted

wherepredicate A predicate limiting the extent of the deletion.

CAUTION: using DELETE without a suitable WHERE clause will empty the table, i.e. all data rows in that table will be deleted.

[Return to SQL Syntax]

Part	Meaning
table	The table from which the data is to be deleted
wherepredicate	A predicate limiting the extent of the deletion.