Difference between DDL and TCL

Prerequisite – SQL Commands

1. Data Definition Language (DDL) :
Data Definition Language as the name suggests, it is used to define database schema. For example : create table, alter table are some of the DDL instructions in SQL.

2. Transaction Control Language (TCL) :
Transaction Control Language as the name suggests, contains those commands, which are used to manage transactions within the database.


Difference between DDL and TCL :

S.No. DDL TCL
1. It stands for Data Definition Language. It stands for Transaction Control Language.
2. It is used to define data structures or overall database schema. It contains those commands, which are used to manage transactions within the database.
3. By using DDL commands, database transactions cannot be handled. TCL commands are meant to handle database transactions.
4. Files can be easily maintained by DDL commands. It manages the different tasks with the important feature, Atomicity.
5. While writing any query, usually DDL statements are written before TCL statements. Usually, TCL statements are written before DDL statements.
6. DDL does not require any log files to maintain the database. It uses log files to keep track of records of all transactions in a database.
7. Some DDL commands which are frequently used : CREATE, ALTER, DROP. Some TCL commands which are frequently used : COMMIT, ROLLBACK.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up


If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.