A COMMIT statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users.[1][2] The general format is to issue a BEGIN WORK statement, one or more SQL statements, and then the COMMIT statement. A COMMIT statement will also release any existing savepoints that may be in use. This means that once a COMMIT statement is issued, you can not rollback the transaction.[1]

In terms of transactions, the opposite of commit is to discard the tentative changes of a transaction, a rollback.

The transaction, commit and rollback concepts are key to the ACID property of databases.[3]

See alsoEdit


  1. ^ a b BYHAM. "COMMIT TRANSACTION (Transact-SQL)". Retrieved 2017-09-29.
  2. ^ "Database SQL Reference". Retrieved 2017-09-29.
  3. ^ "What is ACID (atomicity, consistency, isolation, and durability)? - Definition from". SearchDataManagement. Retrieved 2022-09-27.