SQL language is divided into four types of primary language statements: DML, DDL, DCL and TCL. Using these statements, we can define the. It’s four types of SQL sub-languages, that’s why it’s no sense to search for a difference between DDL vs DML or DCL vs TCL. SQL commands. In this blog we will learn a basic description about DDL, DML, DQL, DCL, TCL in Sql Server.

Author: Tukazahn JoJozragore
Country: Syria
Language: English (Spanish)
Genre: Spiritual
Published (Last): 8 March 2004
Pages: 471
PDF File Size: 16.2 Mb
ePub File Size: 11.97 Mb
ISBN: 787-3-39462-404-7
Downloads: 30994
Price: Free* [*Free Regsitration Required]
Uploader: Tojak

Create Create command is used to create database and its Objects like tables, index, stored procedure, viewstriggers, functions and etc.

Example To create Employee table. Drop Drop command is used to delete objects from database. Truncate Trunctae Table command is used to remove all records from a table, including all spaces allocated for records are removed.


DML, DDL, DCL and TCL Statements in SQL with Examples

Rename It is used to rename the objects. Examples include Insert, Update and Delete. Insert To insert date tc a table. Update To update the existing data in a table.

SQL command types (DDL, DML, DCL and TCL): Definitive Guide

Delete delete all records from a table. So all Select statements comes under DQL.

Select To retreive data from the database table. Grant All users access previleges to database.

Revoke Withdraw users access previleges given by using the Grant command. Commit Commit is used for the permanent changes.

cml When we use Commit in any query then the change made by that query will be permanent and visible. We can’t Rollback after the Commit. Rollback Rollback is used to undo the changes made by any command but only before a commit is done.

DML, DDL, DCL and TCL Statements in SQL with Examples

We can’t Rollback data which has been committed in the database with the help of the commit keyword. Request a new Category View All.


Jaipal Reddy Aug 04