ROLLBACK SQL - Language Statements ROLLBACK abort the current transaction 1999-07-20 ROLLBACK [ WORK | TRANSACTION ] 1998-09-24 None. 1998-09-24 ABORT Message returned if successful. NOTICE: ROLLBACK: no transaction in progress If there is not any transaction currently in progress. 1998-09-24 ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. 1998-09-24 Use to successfully terminate a transaction. is a synonym for ROLLBACK. To abort all changes: ROLLBACK WORK; 1998-09-24 SQL92 only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise full compatibility.