COMMIT

Commits the current transaction to the database. This command makes the database updates from the transaction permanent.

Syntax

COMMIT [ WORK | TRANSACTION ]

Parameters

WORK

Optional keyword. This keyword isn't supported within a stored procedure.

TRANSACTION

Optional keyword. WORK and TRANSACTION are synonyms. Neither is supported within a stored procedure.

For information about using COMMIT within a stored procedure, see Managing transactions.

Examples

Each of the following examples commits the current transaction to the database:

commit;

commit work;

commit transaction;