COMMIT SQL - Language Statements COMMIT commit the current transaction 1999-07-20 COMMIT [ WORK | TRANSACTION ] 1998-09-08 WORK TRANSACTION Optional keywords. They have no effect. 1998-09-08 COMMIT Message returned if the transaction is successfully committed. WARNING: COMMIT: no transaction in progress If there is no transaction in progress. 1998-09-08 COMMIT commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. 1998-09-08 The keywords WORK and TRANSACTION are noise and can be omitted. Use to abort a transaction. To make all changes permanent: COMMIT WORK; 1998-09-08 SQL92 only specifies the two forms COMMIT and COMMIT WORK. Otherwise full compatibility.