Delete data ​

DELETE removes rows satisfying its WHERE condition. Without WHERE, it removes every row but keeps the table definition. DROP TABLE removes the table itself.

Changes complete synchronously and use ordinary transaction rules. Foreign-key actions apply when enabled. TTL, partition drops and background deletion queues are not provided.

Example ​

CREATE TABLE tasks(id INTEGER PRIMARY KEY, completed Bool);
INSERT INTO tasks VALUES (1, true), (2, false);

DELETE FROM tasks
WHERE completed
RETURNING id
FORMAT csv;

1

SELECT id
FROM tasks
FORMAT csv;

2

RETURNING reads deleted values. Use a transaction when the deletion must commit or roll back together with other changes.

See the DELETE reference, DROP and transactions.