ROLLBACK
SQL - Language Statements
ROLLBACK
abort the current transaction
1999-07-20
ROLLBACK [ WORK | TRANSACTION ]
1998-09-24
Inputs
None.
1998-09-24
Outputs
ABORT
Message returned if successful.
NOTICE: ROLLBACK: no transaction in progress
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
Use
to successfully terminate a transaction.
is a
synonym for ROLLBACK.
Usage
To abort all changes:
ROLLBACK WORK;
Compatibility
1998-09-24
SQL92
SQL92 only specifies the two forms ROLLBACK
and ROLLBACK WORK. Otherwise full compatibility.