2.10. ROLLBACK¶
2.10.1. Syntax¶
ROLLBACK [ WORK | TRANSACTION ]
- WORK
- Optional keyword. It has no effect.
- TRANSACTION
- Optional keyword. It has no effect.
2.10.2. Overview¶
ROLLBACK rolls back the current transaction and causes all the updates made
by the transaction to be discarded.
Use COMMIT to successfully terminate a transaction.
Issuing ROLLBACK when not inside a transaction does no harm, but it will
provoke a warning message.
2.10.3. Compatibility¶
The SQL standard only specifies the two forms ROLLBACK and
ROLLBACK WORK.