SQL · Transactions and integrity

rollback

Reverses the current transaction, discarding its changes.

sqlRunnable example sql course

Syntax

rollback

Example

Open in the lab

BEGIN;
CREATE TEMP TABLE notes (body TEXT);
INSERT INTO notes VALUES ('temporary');
ROLLBACK;
-- The table does not exist after the rollback.

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