Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

Difference between DDL and DML in DBMS

  • Difficulty Level : Basic
  • Last Updated : 07 Jul, 2020

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.

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

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:

DDLDML
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.
My Personal Notes arrow_drop_up
Recommended Articles
Page :