What are the acronyms DDL, DML, DQL, DTL and DCL?

Question

I was setting up a permissions structure in the bank (GRANT, REVOKE), when I found this article and found it interesting to share, even to have here at Sopt.

Original issue

• What is DCL?

Source

Answer 1

Think like this, the SQL language is only one, but it is divided into types according to the functionality of the commands.
The SQL language types are:

• DDL - Data Definition Language - Data Definition Language.
  These are commands that interact with bank objects.

  • These are DDL commands : CREATE, ALTER and DROP

• DML - Data Manipulation Language - Data Manipulation Language.
  It is the commands that interact with the data within the tables.

  • DML : INSERT, DELETE and UPDATE commands

• DQL - Data Query Language - Data Query Language.
  These are the query commands.

  • These are DQL commands : SELECT (this is the query command)
    _{Here fits a parentheses. In some books the SELECT stays in the DML in others has this own group.}

• DTL - Data Transaction Language - Data Transaction Language.
  These are the commands for transaction control.

  • DTL : BEGIN TRANSACTION, COMMIT AND ROLLBACK commands

• DCL - Data Control Language - Data Control Language.
  These are the commands to control the security part of the database.

  • DCL commands : GRANT, REVOKE AND DENY.

Original author

Luiz Fernando
Source

Answer 2

A simpler way to be remembered

What differentiates the acronyms is the middle letter.

Such as, for example:

• DML = "M" from the middle comes of Manipulation.
• DDL = "D" from the middle comes of Definition.
• DCL = "C" from the middle comes of Control.
• DTL = "T" from the middle comes of Transaction.
• DQL = "Q" from the middle comes of "Qonsulta".