Rollback a transaction

sql

ROLLBACK;

Explanation

Crucial when a multi-step operation fails partway through.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing transactions

Begin a transaction explicitly.

Open In sheetsqlsame section

Persist all changes made in the current transaction.

Open In sheetsqlsame section

Undo only part of a transaction.

Open In sheetsqlsame section

Keep statements in a transaction until you commit or rollback.

Open In sheetsqlsame section

Control read consistency and concurrency behavior.

Open In sheetsql1 tag match

Prevent concurrent modifications to matched rows inside a transaction.