DELETE

 

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.

 

Examples