SQL/02_SQL_CAMMANDS.sql at main · PriyaTarade/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
SQL Commands:
-------------
DDL : Data Defination Language
----------------
CREATE : This command is used to create objects in DB.
ALTER  : This command is used to modify objects in DB.
DROP   : This command is used to drop objects in DB.
RENAME : This command is used to rename objects in DB.
TRUNCATE :This command is used to remove all data from objects and returns as empty obj.  in DB.
--=============================================================
DML : Data Manipulation Language
------------------------------
SELECT : This command is used to retrieve data from table or objects.
INSERT : This command is used to insert data to table.
UPDATE : This command is used to update existing data from table.
DELETE : This command is used to delete existing some records from table.
---===========================================================
DCL : Data Control Language
-----------------------------------
GRANT : This command is used to grant user permission.
REVOKE: This command is used to remove user permission.
--=============================================================
TCL:Transaction Control Language
------------------------------------
COMMIT   : This command is used to save data permanently.
ROLLBACK : This Command is used to undo save data.
SAVEPOINT: This command is used to save data  at particular stage.
--=============================================================