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.