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

4

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 in SOpt.

Original issue

  • What is DCL?

Font

    
asked by anonymous 14.12.2017 / 12:39

1 answer

7

Think like this, the SQL language is 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.
    They are the commands that interact with the objects of the bank.

    • DDL commands: CREATE, ALTER, and DROP
  • DML - Data Manipulation Language - Data Manipulation Language
    They are the commands that interact with the data within the tables.

    • DML commands: INSERT, DELETE, and UPDATE
  • DQL - Data Query Language - Data Query Language.
    These are the query commands.

    • DQL commands are: SELECT (this is the query command)
      Here, a parentheses. In some books the SELECT stays in the DML in others it has its own group.
  • DTL - Data Transaction Language - Data Transaction Language. These are the commands for transaction control.

    • DTL commands are: BEGIN TRANSACTION, COMMIT AND ROLLBACK
  • 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
Fonte

    
14.12.2017 / 12:39