SQL sublanguages
25 May 2025 (Updated 25 May 2025)
SQL statements fall into one of five sublanguages:
- DQL
- DDL
- DML
- DCL
- TCL
Sublanguage | Description | Example commands |
Data Query Language (DQL-) | Statements that retrieve information from the database. | – SELECT |
Data Definition Language (DDL) | Statements that alter the database schema. | – CREATE – ALTER – UPDATE |
Data Manipulation Language (DML) | Statements that add or update data in the database. | – INSERT – UPDATE – DELETE |
Data Control Language (DCL) | Statements that configure access to the database. | – GRANT – REVOKE |
Data Transaction Language | Statements that manage transactions in the database. | – COMMIT – ROLLBACK |
Tagged:
SQL