SQL · Writing data

delete

Removes matching rows. Prefer soft deletes when audit history or recovery matters.

sqlRunnable example sql course

Syntax

delete from table where …;

Example

Open in the lab

CREATE TEMP TABLE notes (id INTEGER PRIMARY KEY);
INSERT INTO notes VALUES (1), (2);
DELETE FROM notes WHERE id = 2;
SELECT * FROM notes;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.