ROLLBACK
SQL - Language Statements
ROLLBACK
Aborts the current transaction
1999-07-20
ROLLBACK [ WORK | TRANSACTION ]
1998-09-24
Inputs
None.
1998-09-24
Outputs
ABORT
Message returned if successful.
NOTICE: UserAbortTransactionBlock and not in in-progress state
ABORT
If there is not any transaction currently in progress.
1998-09-24
Description
ROLLBACK rolls back the current transaction and causes
all the updates made by the transaction to be discarded.
1998-09-24
Notes
The keywords WORK and TRANSACTION are noise and can be omitted.
Use
to successfully terminate a transaction.
is a
synonym for ROLLBACK.
Usage
To abort all changes:
ROLLBACK WORK;
Compatibility
1998-09-24
SQL92
Full compatibility. The TRANSACTION keyword is a
Postgres extension.