SQL Server DDL, DCL, DML

Explain Data Definition Language, Data Control Language and Data Manipulation Language.

Data Definition Language (DDL):- are the SQL statements that define the database structure.

Example:
a. CREATE
b. ALTER
c. DROP
d. TRUNCATE
e. COMMENT
f. RENAME

Data Manipulation Language (DML):- statements are used for manipulate or edit data.

Example:
a. SELECT - retrieve data from the a database
b. INSERT - insert data into a table
c. UPDATE - updates existing data within a table
d. DELETE
e. MERGE
f. CALL
g. EXPLAIN PLAN
h. LOCK TABLE

Data Control Language (DCL):-statements to take care of the security and authorization.

Examples:
a. GRANT
b. REVOKE

Explain Data Definition Language, Data Control Language and Data Manipulation Language.

Data definition language is used to define and manage all attributes and properties of a database.

Most DDL statements include following commands
CREATE
ALTER
DROP

Data Control Language
Data control language is used to control permissions on database objects. Permissions are controlled by using GRANT, REVOKE, and DENY statement.

Data Manipulation Language
Data manipulation language is used to select, insert, update, and delete data in the objects defined with DDL.