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 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.
|1||Stands for||DDL stands for Data Definition Language.||DML stands for Data Manipulation Language.|
|2||Usage||DDL statements are used to create database, schema, constraints, users, tables etc.||DML statement is used to insert, update or delete the records.|
|3||Classification||DDL has no further classification.||DML is further classified into procedural DML and non-procedural DML.|
|4||Commands||CREATE, DROP, RENAME and ALTER.||INSERT, UPDATE and DELETE.|