ROLLBACK SQL - Language Statements ROLLBACK Aborts the current transaction 1998-09-24 ROLLBACK [ WORK ] 1998-09-24 None. 1998-09-24 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 ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. 1998-09-24 The keyword WORK is noise and can be omitted. Use the COMMIT statement to successfully terminate a transaction. --To abort all changes: -- ROLLBACK WORK; 1998-09-24 Full compatibility.