SQL Delete

The SQL DELETE Statement

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

DELETE Syntax

SQL 
DELETE FROM table_name WHERE condition;

SQL DELETE Example

The following SQL statement deletes the customer “Alfreds Futterkiste” from the “Customers” table:

SQL 
DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';

Delete All Records

It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:

SQL 
DELETE FROM table_name;

The following SQL statement deletes all rows in the “Customers” table, without deleting the table:

SQL 
DELETE FROM Customers;