DDL vs. DML vs. DCL

DDL (Data Definition Language)

• deals with database schemas and descriptions of how the data should reside in the database 
• Example commands : CREATE TABLE , ALTER TABLE

DML (Data Manipulation Language)

• deals with data manipulation 
• Example commands : SELECT, INSERT, etc.

DCL (Data Control Language)

• mostly concerns with rights, permissions and other controls of DBMS 
• Example commands : GRANT