Transaction Control Language
Encyclopedia
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 DML statements. Examples of TCL commands include:
SQL
SQL is a programming language designed for managing data in relational database management systems ....
, 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 DML statements. Examples of TCL commands include:
- COMMITCommit (data management)In the context of computer science and data management, commit refers to the idea of making a set of tentative changes permanent. A popular usage is at the end of a transaction. A commit is an act of committing.-Data management:...
to apply the transaction by saving the database changes. - ROLLBACK to undo all changes of a transaction.
- SAVEPOINTSavepointA savepoint is a way of implementing subtransactions within a relational database management system by indicating a point within a transaction that can be "rolled back to" without affecting any work done in the transaction before the savepoint was created. Multiple savepoints can exist within a...
to divide the transaction into smaller sections. It defines breakpoints for a transaction to allow partial rollbacks.
See also
- Data Definition LanguageData Definition LanguageA data definition language or data description language is a syntax similar to a computer programming language for defining data structures, especially database schemas.-History:...
- Data Manipulation LanguageData Manipulation LanguageA data manipulation language is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database...
- Data Control LanguageData Control LanguageA data control language is a syntax similar to a computer programming language used to control access to data stored in a database. In particular, it is a component of Structured Query Language .Examples of DCL commands include:...