SQL Commands and Functions
Summary
SQL (Structured Query Language) is a standardized language used to create, maintain, modify, and query relational databases. When a user wants to get some information from a database file, he can issue a SQL query.
Types of SQL commands OR Processing capabilities of SQL:
① Data Definition Language Commands (DDL Commands)
② Data Manipulation Language Command (DML Commands)
③ Transaction Control Language Command (TCL commands)
④ Data Control Language (DCL Commands)
DDL Commands
All the commands used to create, modify or delete physical structure of an object like a table. e.g., Create, Alter, Drop.
DML Commands
DML contains commands that can be used to manipulate the database objects and to query the databases for information retrieval.
e.g Select, Insert, Delete, Update etc.
TCL commands
TCL include commands to control the transactions in a database system. The commonly used commands in TCL are COMMIT, ROLLBACK etc.
Data Control Language (DCL)
This language is used for controlling the access to the data. Various commands like GRANT, REVOKE etc are available in DCL.