Skip to main content

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