The DELETE statement is the DML one providing a way to delete existing records.
Syntax of the DELETE statement
DELETE FROM table_name[ WHERE where_criteria]
Comments
table_name | The name of a table where records are located. |
WHERE where_criteria | Determines records that will be deleted. If not used, then all records will be deleted. Refer to the chapter WHERE for more details. |