604

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.