The SQL DELETE Statement

The DELETE statement is used to delete existing records in a table.

Syntax

    DELETE FROM table_name WHERE condition;

Output

The column parameters specify the names of the columns of the table.

The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).