Monday, December 19, 2011

Difference between DML DDL DCL and TCL?




DML:

DML is abbreviation of Data manipulation Language. It is useed to work with the data of the tables.

Basic Statements: SELECT, UPDATE, INSERT, delete statements.
DDL:

DDL is abbreviation of Data Defination Language. It is used to build and modify the structure of your tables and other objects in a database.

Basic Statements: CREATE, ALTER, RENAME, DROP and TRUNCATE statements.


DCL:

DCL is abbrivation 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.

Basic Statements: GRANT, REVOKE statements.

TCL:

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

Basic Statements:COMMIT, ROLLBACK statements.

No comments: