TurboDB Engine Documentation
DELETE
Previous  Top  Next


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.