Jan 4, 2015

What is DML, DDL, DCL and TCL in SQL- Server


DML is stand for Data Manipulation Language. DML is responsible to retrieve, store, modify, delete, insert and update data in database.


DDL is stand for Data Definition Language. DDL is responsible to create and modify the structure of database objects in database.
Examples: CREATE, ALTER, DROP statements


DCL is stand for Data Control Language. DCL is responsible to  roles, permissions, and referential integrity and also use to control access to database by securing it.
Examples: GRANT, REVOKE statements


TCL is stand for Transactional Control Language. TCL is responsible to manage different transactions occurring within a database.
Examples: COMMIT, ROLLBACK statements