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]
|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.|