DELETE Statement

The DELETE statement is used to delete existing records in a table.

[!CAUTION] Like UPDATE, if you omit the WHERE clause, ALL records in the table will be DELETED!

Syntax

DELETE FROM table_name
WHERE condition;

Example

Delete the customer "Alfreds Futterkiste" from the "Customers" table.

DELETE FROM Customers
WHERE CustomerName = 'Alfreds Futterkiste';

Delete All Records

To delete all rows in a table without deleting the table structure itself:

DELETE FROM table_name;

Or slightly faster in some DBs (but cannot be rolled back in some cases):

TRUNCATE TABLE table_name;