SQL DELETE Statement
How do I delete records in SQL?
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 SQL DELETE syntax
The general syntax is
DELETE table-name
To delete specific records append a WHERE clause:
DELETE table-name WHERE condition
PRODUCT |
---|
Id |
ProductName |
SupplierId |
UnitPrice |
Package |
IsDiscontinued |
SQL DELETE Examples
Problem: Delete all products.
DELETE Product
Result: 77 records deleted.
PRODUCT |
---|
Id |
ProductName |
SupplierId |
UnitPrice |
Package |
IsDiscontinued |
Problem: Delete products over $50.
DELETE Product WHERE UnitPrice > 50
Result: 7 records deleted.
CUSTOMER |
---|
Id |
FirstName |
LastName |
City |
Country |
Phone |
Problem: Delete customer with Id = 21.
DELETE Customer WHERE Id = 21
This is a common scenario in which a single record is deleted.
Result: 1 record deleted.