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:
To delete specific records append a WHERE clause:
SQL DELETE Examples
Problem: Delete all products.
Problem: Delete products over 100.
WHERE UnitPrice > 100
Problem: Delete customer with Id = 21.
WHERE Id = 21
This is a more common scenario in which a single record is deleted.