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. Examples of TCL commands include:

• COMMIT to apply the transaction.
• ROLLBACK to undo all changes of a transaction.
• SAVEPOINT to divide the transaction into smaller sections.

[edit] See also

• Data Definition Language
• Data Manipulation Language
• Data Control Language

v • d • e Database management systems Database models · Database normalization · Database storage · Distributed DBMS · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Object-relational database · Transaction processing Concepts Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key Objects Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition SQL Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter Implementations Relational · Flat file · Deductive · Dimensional · Hierarchical · Network · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores · Triple stores Components Concurrency control · Data dictionary · JDBC · ODBC · Query language · Query optimizer · Query plan Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented