DDL, DQL, DML, DCL, and TCL Commands

DDL, DQL, DML, DCL and TCL Commands

These SQL (Structured Query Language) commands are mainly categorized into four categories:

  1. DDL – Data Definition Language
  2. DQl – Data Query Language
  3. DML – Data Manipulation Language
  4. 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

Leave a Reply

Your email address will not be published. Required fields are marked *