ROLLBACK() SQL Commands ROLLBACK()NAMEROLLBACK - Aborts the current transaction
SYNOPSISROLLBACK [ WORK | TRANSACTION ]
INPUTS
None.
OUTPUTS
ABORT Message returned if successful.
NOTICE: ROLLBACK: no transaction in progress
If there is not any transaction currently in progress.
DESCRIPTIONROLLBACK rolls back the current transaction and causes all the updates
made by the transaction to be discarded.
NOTES
Use COMMIT [commit(l)] to successfully terminate a transaction. ABORT
[abort(l)] is a synonym for ROLLBACK.
USAGE
To abort all changes:
ROLLBACK WORK;
COMPATIBILITY
SQL92
SQL92 only specifies the two forms ROLLBACK and ROLLBACK WORK. Other‐
wise full compatibility.
SQL - Language Statements 29 March 2001 ROLLBACK()