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.