SQL - Transaction Control (TCL)

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

Table of Contents

1 - 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
Advertising