COMMIT (SQL)
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.
See also
References
- 1 2 BYHAM. "COMMIT TRANSACTION (Transact-SQL)". docs.microsoft.com. Retrieved 2017-09-29.
- ↑ "Database SQL Reference". docs.oracle.com. Retrieved 2017-09-29.
This article is issued from
Wikipedia.
The text is licensed under Creative Commons - Attribution - Sharealike.
Additional terms may apply for the media files.