Monday, November 2, 2009

DML, DDL, DCL, TCL, DQL

When we discuss, when I teach, the mostly discussed SQL Server related languages are DML and DDL. But do you know that there are few more categories, they are DCL, TCL and DQL. Here is a brief note of it; DML - Data Manipulation Language - statements that perform changes to the database. Eg. INSERT, UPDATE, DELETE DDL - Data Definition Language - statements that modify objects in the database. Eg. CREATE TABLE, CREATE VIEW, DROP PROCEDURE DCL - Data Control Language - statements that controls the rights to objects. Eg. GRANT, DENY, REVOKE TCL - Transactional Control Language - statements that controls transactions in the database. Eg. COMMIT, ROLLBACK, SAVE POINT DQL - Data Query Language - statements that query the database. Eg. SELECT