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. The general format is to issue a BEGIN WORK statement, one or more SQL statements, and then the COMMIT statement. Alternatively, a ROLLBACK statement can be issued, which undoes all the work performed since BEGIN WORK was issued. A COMMIT statement will also release any existing savepoints that may be in use.

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

Database management systems

Types	Object-oriented comparison Relational comparison Document-oriented Graph NoSQL NewSQL

Concepts	Database ACID CAP theorem CRUD Null Candidate key Foreign key Primary key Superkey Surrogate key Armstrong's axioms

Objects	Relation table column row View Transaction Log Trigger Index Stored procedure Cursor Partition

Components	Concurrency control Data dictionary JDBC XQJ ODBC Query language Query optimizer Query plan

Functions	Administration and automation Query optimization Replication

Related topics	Database models Database normalization Database storage Distributed DBMS Federated database system Referential integrity Relational algebra Relational calculus Relational database Relational DBMS Relational model Object-relational database Transaction processing

This article is issued from Wikipedia - version of the Thursday, April 09, 2015. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.

COMMIT (SQL)

See also