Prerequisite – DDL, DQL, DML, DCL and TCL Commands
DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL.
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:
|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.|