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


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.