ROLLBACK() SQL Commands ROLLBACK() NAME ROLLBACK - Aborts the current transaction SYNOPSIS ROLLBACK [ 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. DESCRIPTION ROLLBACK 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()[top]
Vote for polarhome |