SQL DELETE Statement

  • DELETE permanently removes records from a table.
  • DELETE can delete one or more records in a table.
  • Use the WHERE clause to DELETE only specific records.
The definitive guide
for data professionals


Order today!
 See 2 min video



The SQL DELETE syntax


The general syntax is:
DELETE table-name 

To delete specific records append a WHERE clause:
DELETE table-name 
 WHERE condition




SQL DELETE Examples



Problem: Delete all products.
DELETE Product



Results: 77 records deleted.







Problem: Delete products over $50.
DELETE Product
 WHERE UnitPrice > 50



Results: 7 records deleted.







Problem: Delete customer with Id = 21.
DELETE Customer
 WHERE Id = 21

This is a more common scenario in which a single record is deleted.


Results: 1 record deleted.