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.

Written by 

Salesforce MVP | Lightning Champion | 16x Salesforce Certified | Application Architect | 6x Trailhead Ranger | Techforce Services | Australia

Leave a Reply

Your email address will not be published. Required fields are marked *

*