COMMIT
SQL - Language Statements
COMMIT
Commits the current transaction
1998-04-15
COMMIT [ WORK ]
1998-04-15
Inputs
None
1998-04-15
Outputs
END
Message returned if the transaction is successfully committed.
NOTICE EndTransactionBlock and not inprogress/abort state
If there is no transaction in progress.
1998-04-15
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-04-15
Notes
The keyword WORK is noise and can be omitted.
Refer to ROLLBACK statements to abort a transaction.
Usage
To make all changes permanent:
COMMIT WORK;
Compatibility
1998-04-15
SQL92
Full compatibility.