SQL DELETE

SQL DELETE Statement

SQL DELETE permanently removes rows from a table.

DELETE can delete one or more records in a table.

Use the WHERE clause to DELETE only specific records.

Problem: Remove customer Elizabeth Lincoln who lives in Canada.

copy

copied to clipboard

DELETE Customer
 WHERE FirstName = 'Elizabeth' 
   AND LastName = 'Lincoln'
   AND Country = 'Canada'

DELETE Customer
 WHERE FirstName = 'Elizabeth' 
   AND LastName = 'Lincoln'
   AND Country = 'Canada'

DELETE syntax.

DELETE table-name 

DELETE syntax with WHERE.

DELETE table-name 
 WHERE condition

copy

copied to clipboard

DELETE Product

DELETE Product

copy

copied to clipboard

DELETE Product
 WHERE UnitPrice > 50

DELETE Product
 WHERE UnitPrice > 50

copy

copied to clipboard

DELETE Customer
 WHERE Id = 21

DELETE Customer
 WHERE Id = 21

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

• Our Sql SELECT Reference
• Our Sql INSERT Reference
• Our Sql JOIN Reference
• Our Sql WHERE Reference