SQL · Transactions and integrity

savepoint

Marks a point inside a transaction so part of it can be rolled back.

sqlRunnable example sql course

Syntax

savepoint name / rollback to name

Example

Open in the lab

BEGIN;
SAVEPOINT before_insert;
CREATE TEMP TABLE notes (body TEXT);
INSERT INTO notes VALUES ('x');
ROLLBACK TO before_insert;
COMMIT;

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