sajad torkamani

SQL sublanguages

25 May 2025 (Updated 25 May 2025)

SQL statements fall into one of five sublanguages:

  1. DQL
  2. DDL
  3. DML
  4. DCL
  5. TCL

SublanguageDescription 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 LanguageStatements that manage transactions in the database.– COMMIT
– ROLLBACK
Tagged: SQL