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 :
|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.|