Geeks With Blogs
Gokul G
| Home |

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.

Examples: COMMIT, ROLLBACK statements

*************************************************************************************************************************************

DR (Data Retrivel Language) : Select.
DML : Insert, Update, Delete, Merge.
DDL : Create, Alter, Drop, Rename, Truncate.
TC : Commit, Rollback, Savepoint.
DCL : Grant, Revoke.

*************************************************************************************************************************************

DDL(Data Defination Language):
DDL is used to create the structure of the table. DDL commands are CREATE —Used to create any objects(Table,View,Trigger,Stored procedure) in the database. ALTER – Used to modify the objects in the database.DROP –this command used to drop the objects with the structure.TRUNCATE–This command also used to delete the objects. RENAME–used to modify the object name in the data base.

DML(Data Manipulation Language):
DDL commands used to create the objects, DML commands used to manipulate the objects. DML commands are INSERT–This command is used to insert the records into table, UPDATE–This command is used to update the record which is already exisiting in the table, DELETE– This command is used to delete the record which is already existing the table. It is deletes only records not the structure.

DRL(Data Retrivel Language):
DRL Command used to retrive the datafrom the database.
SELECT command used to retrive the data.

DCL(Data contole Language):
DCL commands used to security purpose.
GRANT–this command used to give the pemissons to the paricular Data.
REVOKE–This command used to release the permissions, which already given to any user.

*************************************************************************************************************************************

Source: http://blog.sqlauthority.com/2008/01/15/sql-server-what-is-dml-ddl-dcl-and-tcl-introduction-and-examples/

Posted on Thursday, October 14, 2010 10:49 AM | Back to top


Comments on this post: DML, DDL, DCL and TCL

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Gokul | Powered by: GeeksWithBlogs.net