Database Guide
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.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]