TSQL - What Type of Commands Are Available In TSQL?

There are three types of Commands available in TSQL

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.

No comments:

Post a Comment