SQL: What are DDL, DML, DQL, DCL and TCL? ๐งต๐
1. Introduction
The SQL commands are categorized into the following categories:
DDL - Data Definition Language
DML - Data Manipulation Language
DQL - Data Query Language
DCL - Data Control Language
TCL - Transaction Control Language
Let's see each of them in detail.
2. DDL
Queries like - CREATE, DROP, TRUNCATE, and ALTER fall into this category because they all manage the structure of DB Objects in some way.
For eg: CREATE command creates the structure of a table, DROP command removes the table structure.