Intoduction: In this article today I am going to explain Sql commands and its types.
In the previous article I have explained Copy data from one table to another existing table in sql server, Get multiple selected values from Listbox in asp.net, Explain cookies in asp.net OR Explain cookies with example in asp.net and Move items from one listbox to another listbox and vice versa in asp.net.
Sql commands are the set of instructions which are connect/ interact with database to perform specific task.
Types of Sql command:
Sql commands are grouped into five (5) major categories depending on their functionality.
1). DDL: DDL stand for Data Definition Language. These commands are used to creating, modifying, and dropping the structure of database objects. The examples of DDL commands are CREATE, ALTER, DROP, RENAME and TRUNCATE.
2). DQL: DQL stand for Data Query Language. DQL commands are used to retrieve the data from database tables. SELECT is the only example of DQL commands.
3). DML: DML stand for Data Manipulation Language. These commands are used to retrieve, store, modify, and delete data in database tables. The examples of DML commands are UPDATE, INSERT and DELETE.
4). TCL: TCL stand for Transaction Control Language. TCL commands are used to manage the changes made by DML statements. Examples of DCL command are COMMIT, ROLLBACK, and SAVEPOINT.
5). DCL: DCL stand for Data Control Language. DCL commands are used to implement security on database objects. Examples of DCL command are GRANT and REVOKE.
Is this article helpful for you?
If yes post your comment to appreciate my work and fell free to contact me. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.
What do you think about this article?
If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.