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.
No comments:
Post a Comment