COMMIT
SQL - Language Statements
COMMIT
Commits the current transaction
1998-09-08
COMMIT [ WORK | TRANSACTION ]
1998-09-08
Inputs
None
1998-09-08
Outputs
status
END
Message returned if the transaction is successfully committed.
NOTICE EndTransactionBlock and not inprogress/abort state
If there is no transaction in progress.
1998-09-08
Description
COMMIT commits the current transaction. All
changes made by the transaction become visible to others
and are guaranteed to be durable if a crash occurs.
1998-09-08
Notes
The keywords WORK and TRANSACTION are noise and can be omitted.
Use the ROLLBACK statement to abort a transaction.
Usage
To make all changes permanent:
COMMIT WORK;
Compatibility
1998-09-08
SQL92
Full compatibility.