SQL SERVER What is DML, DDL, DCL and TCL

Posted by Joggee | SQL Server 2005, SQL Sever, SQL Tips and Tricks | Thursday 17 January 2008 6:04 am

DML
DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements

DDL
DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database. Examples: CREATE, ALTER, DROP statements

DCL
DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. Examples: GRANT, REVOKE statements

TCL
TCL is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.

Thanks to Pinal Dave. 

3 Comments »

  1. Comment by Sohaib Ahmad — January 17, 2008 @ 7:27 am

    DML, DDL, DCL and TCL all these are very helpful for interview. Now i come to know that who manage the databese statements, its structure, transactions defined in the database and who manage roles, permissions, and referential integrity defined in the database.
    Great Thanks.

  2. Comment by pinaldave — February 7, 2008 @ 8:49 am

    Rana,

    You should link to my original article : http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/

    Also my last name is incorrect, it should be Dave.

    Your blog have some good ASP.NET articles.

    Regards,
    Pinal

  3. Comment by codeproject — February 7, 2008 @ 11:26 am

    Dear Dave,

    I have changed your last name in my post.

    Keep visiting to me.

    Thanks,
    Rana

RSS feed for comments on this post. TrackBack URI

Leave a comment