|
Makes changes to the database permanent.
COMMIT [ WORK ]
WORK is an optional keyword.
A transaction is the inserts, updates, and deletes performed on one database connection to a database between COMMIT or ROLLBACK statements. The COMMIT statement ends a transaction and makes all changes made during this transaction permanent in the database.
ALTER, CREATE, and DROP statements are committed automatically.