SQL - Transaction Control (TCL)

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

Powered by ComboStrap