DELETE

SQL command to delete rows from a table.

Syntax

Parameters

tableName

The name of the target table

predicate

A predicate which should evaluate to true for the given row to be updated

Examples

Delete all rows

SELECT * FROM T;

A	B	C
1	"one"	1.0
2	"two"	2.0
3	"three"	NULL
4	"four"	NULL

DELETE FROM T;

SELECT * FROM T;

A	B	C

Update all rows matching a give predicate

SELECT * FROM T;

A	B	C
1	"one"	1.0
2	"two"	2.0
3	"three"	NULL
4	"four"	NULL

DELETE FROM T WHERE C IS NOT NULL;

SELECT * FROM T;

A	B	C
3	"three"	NULL
4	"four"	NULL