SQL DELETE statement
An SQL DELETE statement is used to delete specified rows from a table or view in the database.
A DELETE statement consists of the following types of clauses:
DELETE FROM clause
The DELETE FROM clause of a DELETE statement specifies the table or view rows are to be deleted from.
WHERE clause
The WHERE clause of a DELETE statement specifies a condition that restricts which rows are to be deleted. Only the rows for which the condition is true will be deleted.
The WHERE clause is optional. If it is not specified, all the rows in the table or view will be deleted.
Last modified date: 01/29/2015