Tuesday, 9 February 2016

SQL SERVER -- SQL Commands -- Part-2

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:

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