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

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.

You may also like

Leave a Comment