Topic: What is DDL, DML and DCL?

[johnniwales]

DML means Data Manipulation Language: statements used for managing data within schema objects. DCL means Data Control Language. DDL means Data Definition Language: statements used to define the database structure or schema.

[Maddy]

DDL-Data Definition Language deals with database schemas and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL.

DML-DML deals with data manipulation, and therefore includes most common SQL statements such SELECT, INSERT, etc.

DCL-Data Control Language includes commands such as GRANT, and mostly concerns with rights, permissions and other controls of the database system.

Regards

[SEOLearner]

Just recently a friend of mine brought up these databases and they don't sound familiar.  Can anyone explain these database terms?