Difference between DML (Data Manipulation Language) and DDL (Data Definition Language)

DML (Data Manipulation Language) and DDL (Data Definition Language)

Subsets of SQL commands:

DML (Data Manipulation Language) is the set of commands which modify the data itself. A few of these common commands are:

SELECT
UPDATE
INSERT
DELETE

DDL (Data Definition Language) is the set of commands which modify the schema, or structure of the database. This includes commands such as:
CREATE
DROP
ALTER
TRUNCATE

Check out the Wikipedia articles for DML and DDL for more information.

(3)

Written by 

I am Sakthivel Madesh, a certified Salesforce Developer & Administrator working on Salesforce Technology since 2011. I am currently working in IBM Austraila as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 10 Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply