Pr.Pg Next Pg

Categories of T-SQL Statements tutorials

SQL statements are categories in 3 main category called

a)     Data Manipulation Language (DML),

b)    Data Definition Language (DDL),

c)     Data Control Language (DCL),

 

Each of these categories is describe as follow:

DML

DDL

DCL

Stands for Data Manipulation Language

Stands for Data Definition Language

Stands for Data Control Language

Statements used for querying and modifying data

Statement used for Object Definitions and lifecycle of database objects.

Statements used for Security permission

For example

INSERT,

UPDATE,

DELETE

For example

CREATE,

ALTER,

DROP

For example

GRANT

REVOKE

DENY

 

  • Data Query Language or DQL: DQL is only a statement use for querying a data DQL includes statement SELECT.

 


 

Pr.Pg border                                              Next Pg