These SQL (Structured Query Language) commands are mainly categorized into four categories:
- DDL – Data Definition Language
- DQl – Data Query Language
- DML – Data Manipulation Language
- DCL – Data Control Language
DDL (Data Definition Language)
A database system provides a data-definition language (DDL) to specify the database schema
List of DDL commands:
• CREATE
• DROP
• ALTER
• TRUNCATE
• COMMENT
• RENAME
DQL (Data Query Language)
DQL statements are used for performing queries on the data within schema objects.
List of DQL commands:
- SELECT
DML(Data Manipulation Language)
A data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate model.
List of DML commands:
• INSERT
• UPDATE
• DELETE
DCL (Data Control Language)
A data control language (DCL) is used to control access (Authorization) to data stored in a database
List of DCL commands:
• GRANT
• REVOKE
TCL (Transaction Control Language)
A transaction control language (TCL) is used to control transactional processing in a database
List of TCL commands:
• COMMIT
• ROLLBACK
• SAVEPOINT
• SET TRANSACTION