Command |
What it does |
COMMIT |
This command saves all database changes permanently to the database. A COMMIT ends the transaction. |
ROLLBACK |
This command removes all database changes that were pending in the transaction, returning the database to it state prior to
the beginning of the transaction. A ROLLBACKROLLBACK ends the transaction. |
SAVEPOINT |
This command marks a point somewhere within a transaction. You can roll back to a SAVEPOINT and only the
database changes processed after that SAVEPOINT are removed. A SAVEPOINT does not end the
transaction. |