Difference between DDL and DML in DBMS.

DBMSDatabaseData Structure

DDL

DDL is Data Definition Language and is used to define the structures like schema, database, tables, constraints etc. Examples of DDL are create and alter statements.

DML

DML is Data Manipulation Language and is used to manipulate data. Examples of DML are insert, update and delete statements.

Following are the important differences between DDL and DML.

Sr. No.KeyDDLDML
1Stands forDDL stands for Data Definition Language.DML stands for Data Manipulation Language.
2UsageDDL statements are used to create database, schema, constraints, users, tables etc.DML statement is used to insert, update or delete the records.
3ClassificationDDL has no further classification.DML is further classified into procedural DML and non-procedural DML.
4CommandsCREATE, DROP, RENAME and ALTER.INSERT, UPDATE and DELETE.
raja
Published on 28-Nov-2019 10:33:05
Advertisements