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.
in Austin, Texas