Commit a transaction.

 

Syntax

 

<commit statement> ::= COMMIT [ WORK ]

 

 

Usage

 

The COMMIT statement terminates the active transaction and makes all changes made during the transaction permanent in the database.

 

 

Notes

 

The COMMIT statement will return an error if no transaction is active.



 

 

Examples

 

1)

The following example commits the current transaction:



 


COMMIT;



 

 


 

Conformance

 

SQL:2003 standard

-

Core SQL