sajad torkamani

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