Transaction Control Language

From Wikipedia, the free encyclopedia
Jump to: navigation, search

A Transaction Control Language (TCL) is a computer language and a subset of SQL, used to control transactional processing in a database. A transaction is logical unit of work that comprises one or more SQL statements, usually a group of Data Manipulation Language (DML) statements.

Examples of TCL commands include:

  • COMMIT to apply the transaction by saving the database changes.
  • ROLLBACK to undo all changes of a transaction.
  • SAVEPOINT to divide the transaction into smaller sections. It defines breakpoints for a transaction to allow partial rollbacks.

See also[edit]