COMMIT [ WORK | TRANSACTION ]
Optional keywords. They have no effect.
Message returned if the transaction is successfully committed.
If there is no transaction in progress.
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.
The keywords WORK and TRANSACTION are noise and can be omitted.
Use ROLLBACK to abort a transaction.
To make all changes permanent:
SQL92 only specifies the two forms COMMIT and COMMIT WORK. Otherwise full compatibility.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.