Differentiate between DDL and DML commands in SQL.

Answer»

DDL(Data Definition Language)	DML(Data Manipulation Language)
DDL is USED to define database SCHEMA and also to define some constraints	DML is used to manipulate the data within the database
Does not have further classification	Classified into procedural and non-procedural DML
DDL statements do not use WHERE clause	DML statements use WHERE clause
Examples for DDL statements are CREATE, ALTER, DROP, TRUNCATE, COMMENT, and RENAME	Examples for DML statements are INSERT, UPDATE, and DELETE

Discussion