Difference between DDL and DML in DBMS
Prerequisite – DDL, DQL, DML, DCL and TCL Commands
DDL:
DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL.
DML:
DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions in SQL.
Difference between DDL and DML:
DDL | DML |
---|---|
It stands for Data Definition Language. | It stands for Data Manipulation Language. |
It is used to create database schema and can be used to define some constraints as well. | It is used to add, retrieve or update the data. |
It basically defines the column (Attributes) of the table. | It add or update the row of the table. These rows are called as tuple. |
It doesn’t have any further classification. | It is further classified into Procedural and Non-Procedural DML. |
Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc. | BASIC command present in DML are UPDATE, INSERT, MERGE etc. |
DDL does not use WHERE clause in its statement. | While DML uses WHERE clause in its statement. |