Deletes one or more rows from a table.

DELETE FROM table_reference
[WHERE predicates]

Description

Use DELETE to delete one or more rows from an existing table.

DELETE FROM "employee.dat"

The optional WHERE clause restricts row deletions to a subset of rows in the table. If no WHERE clause is specified, all rows in the table are deleted.

DELETE FROM "employee.dat"
WHERE empno > 2300

The table reference cannot be passed to the DELETE statement via a parameter.

Important Note:

The DELETE statement without WHERE clause deletes all rows of a table without checking constraints like foreign keys. This is a feature to provide fast table emptying.