The DELETE statement removes rows from a table. The DELETE statement has the following syntax:
DELETE FROM table_name
[ WHEREsearch_condition
]
Note: There are additional options to DELETE depending on your database. For a complete syntax description for DELETE, see the product documentation.
You can remove all rows from a table using a statement in the form:
DELETE FROM employees
Typically, you specify a WHERE clause to the DELETE statement to delete specific rows of the table. For example, the following statement deletes John Smith from the table:
DELETE FROM employees WHERE EmpID=51