COMMIT statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users. 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.
In terms of transactions, the opposite of commit is to discard the tentative changes of a transaction, a rollback.
- BYHAM. "COMMIT TRANSACTION (Transact-SQL)". docs.microsoft.com. Retrieved 2017-09-29.
- "Database SQL Reference". docs.oracle.com. Retrieved 2017-09-29.
- "What is ACID (atomicity, consistency, isolation, and durability)? - Definition from WhatIs.com". SearchDataManagement. Retrieved 2022-09-27.