DELETE statement

The SQL statement that removes rows from a table, choosing them with WHERE.

In more detail

Without WHERE it empties the table. Foreign keys may refuse the delete, or cascade it to child rows. For records with lasting value, prefer a soft delete, and log or archive destructive operations.

Related terms

Taught in

References