DCL, DML, DDL Commands of SQL Server

SQL Server - Types of Commands Available In SQL?

There are three types of Commands available in SQL Server

DCL (Data Control Language) :

These commands are used to control the permission on objects such as tables, views, stored procedures and functions etc.

For Example:

Grant and Deny are the commands which can be used to grant permission on objects or deny.

DML (Data Manipulation Language):

DML commands are used to select data, update, delete and insert.

For Example:

Select * from dbo.Table

Update Table

Delete from Table

Insert into dbo.Table

DDL (Data Definition Language):

DDL commands are used to create, drop or alter database objects.

For Example:

Create table, Drop table, Alter table, and Create SP etc. Truncate is also considered DDL command.

For more Information please visit the following link this is a copied version:

http://sqlage.blogspot.in/2014_08_01_archive.html