ROLLBACK
ROLLBACK — Abort the current transaction
Synopsis
ROLLBACK [ WORK | TRANSACTION ] [ AND [ NO ] CHAIN ]
Description
ROLLBACK rolls back the current transaction and causes all updates made by the transaction to be discarded.
Parameters
WORK
TRANSACTION
Optional keywords with no effect.
AND CHAIN
If AND CHAIN is specified, a new transaction is immediately started with the same transaction characteristics as the just-completed transaction (see SET TRANSACTION). Otherwise, no new transaction is started.
Notes
Use COMMIT to successfully terminate a transaction.
Issuing ROLLBACK outside a transaction block will issue a warning and have no effect. ROLLBACK AND CHAIN outside a transaction block is an error.
Examples
-- To abort all changes:
ROLLBACK;