ROLLBACK

Use ROLLBACK to discard uncommitted data changes in the current transaction.

Syntax

ROLLBACK;

Example

Run this example on the same client connection in a test database you own. It creates a test table and removes it afterwards.

CREATE TABLE txn_example (id INT PRIMARY KEY);
BEGIN;
INSERT INTO txn_example VALUES (1);
ROLLBACK;
SELECT COUNT(*) FROM txn_example;
DROP TABLE txn_example;

The count after rollback is 0.

See Transactions and INSERT.

Last updated on Oct 19, 2026