SQL SERVER -- SQL Commands -- Part-2
Types of SQL Commands?
Whenever user interacts with a database, the software translates your commands (whether they are mouse clicks or form entries) into SQL statement that the database knows how to interpret. SQL has five major components that means five most commands.
There are 5 types of commands:
Whenever user interacts with a database, the software translates your commands (whether they are mouse clicks or form entries) into SQL statement that the database knows how to interpret. SQL has five major components that means five most commands.
There are 5 types of commands:
1. DDL(Data
Definition Language)
§ CREATE
§ ALTER
§ DROP
2. DML(Data
Manipulation Language)
§ INSERT
§ UPDATE
§ DELETE
§ MERGE
3. DRL (Data
Retrieval Language)
§ SELECT
4. TCL (Transaction Control Language)
§ COMMIT
§ ROLLBACK
5. DCL (Data
Control Language)
§ GRANT
§ REVOKE
1. DDL(Data
Definition Language)
§ CREATE
§ ALTER
§ DROP
2. DML(Data
Manipulation Language)
§ INSERT
§ UPDATE
§ DELETE
§ MERGE
3. DRL (Data
Retrieval Language)
§ SELECT
4. TCL (Transaction Control Language)
§ COMMIT
§ ROLLBACK
5. DCL (Data
Control Language)
§ GRANT
§ REVOKE
No comments:
Post a Comment