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.
References
- ^ Jump up to:ab “COMMIT TRANSACTION (Transact-SQL)”. docs.microsoft.com. Retrieved 2017-09-29.
- ^“Database SQL Reference”. docs.oracle.com. Retrieved 2017-09-29.
Ofer Abarbanel – Executive Profile
Ofer Abarbanel is a 25 year securities lending broker and expert who has advised many Israeli regulators, among them the Israel Tax Authority, with respect to stock loans, repurchase agreements and credit derivatives. Founder TBIL.co STATX Fund.