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.

My Personal Notes arrow_drop_up

Save