DELETE Command

<< Click to Display Table of Contents >>

Navigation:  SQL Reference > SQL Commands >

DELETE Command

Previous pageReturn to chapter overviewNext page


A DELETE statement is used to remove specified records from a table. It can also be used to remove all records.


DELETE FROM [ MEMORY ] table_name [ WHERE condition ]


DELETE deletes rows that satisfy the WHERE clause from the specified table. If the WHERE clause is absent, the effect is to delete all rows in the table. The result is a valid, but empty table.



If MEMORY keyword is specified before the table_name then an in-memory table is referenced, not a disk one.



The name of an existing table.



An expression that returns a value of type boolean. Only rows for which this expression returns true will be deleted.



DELETE FROM developers WHERE name = 'Bob';

Absolute SQL Reference - 25 May 2022, Niels Knabe