SQL - Transaction Control (TCL)
Table of Contents
About
In SQL, TCL means Transaction Control and is a set of commands that manage the effectiveness of a DML action.
The principal commands are:
- COMMIT to validate the changes
- ROLLBACK to cancel the changes and return to the previous state of the data (since the last COMMIT)
but you can also find:
- SAVEPOINT to create a point in a transaction (series of SQL statement) where you can later roll back
- SET TRANSACTION to change transaction properties like isolation level, which rollback segment to use
- SET CONSTRAINT
