ROLLBACK [ WORK | TRANSACTION ]
None.
Message returned if successful.
If there is not any transaction currently in progress.
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. ABORT is a synonym for ROLLBACK.
To abort all changes:
ROLLBACK WORK;
SQL92 only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise full compatibility.
