Jump to content

Commit (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Turnstep (talk | contribs) at 17:16, 21 March 2005 (SQL COMMIT command). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

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.