DELETE Statement

Access SQL
  • Syntax
  • Examples
  • Advanced


FROM TableName
WHERE Column = Value;

What does it do?
The DELETE statement will delete all rows that are selected by the WHERE constraint. If the Where clause is omitted, all the rows in the table will be deleted. It is very important to add a WHERE clause for the DELETE statement.

Note: You cannot select specific columns to be deleted with this statement, therefor an asterisk(*) is always used in place of columns.


FROM Customers
WHERE CustomerID = 5;


Blue - Is used to identify reserved keywords/characters that are used by the SQL engine, i.e. SELECT, FROM, or WHERE.

Purple - Is used to identify portions of the SQL statement that are defined by the user, i.e. Column Names, Table Names, Inputed Values.