Transactions

Rollback

English

Overview

An operation that cancels a transaction and reverts to its pre-execution state.

Details

An operation that discards changes made within a transaction and reverts to the state before it began, used to maintain consistency when an error occurs. Beyond an application explicitly calling ROLLBACK, the database itself can trigger one automatically too -- for instance, when a connection drops unexpectedly or a deadlock is detected.

More Database terms