Transaction Control Language

From Wikipedia, the free 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 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.

v t e Database management systems

Database models Database normalization Database storage Distributed DBMS Federated database system Referential integrity Relational algebra Relational calculus Relational database Relational DBMS Relational model Object-relational database Transaction processing

Concepts	Database ACID CRUD Null Candidate key Foreign key Primary key Superkey Surrogate key Armstrong's axioms

Objects	Relation table column row View Transaction Log Trigger Index Stored procedure Cursor Partition

Components	Concurrency control Data dictionary JDBC XQJ ODBC Query language Query optimizer Query plan

Functions	Administration and automation Query optimization Replication

Database products Object-oriented comparison Relational comparison Document-oriented Graph database NoSQL NewSQL

This article is issued from Wikipedia. The text is available under the Creative Commons Attribution/Share Alike; additional terms may apply for the media files.

Transaction Control Language

See also