SQL Commands

 SQL commands are categorized into the following categories:

  • DDL : Data Definition Language
  • DQL : Data Query Language
  • DCL : Data Control Language
  • DML : Data Manipulation Language
  • TCL : Transaction Control Language

Under these five categories, the following commands are defined

        1. DDL
    • CREATE
    • DROP
    • ALTER
    • TRUNCATE
    • RENAME

        2. DML
    • INSERT 
    • UPDATE
    • DELETE
    • CALL
    • LOCK

        3. DQL
    • SELECT
        
        4. DCL
    • GRANT
    • REVOKE
                
        5. TCL
    • SAVEPOINT
    • COMMIT
    • ROLLBACK

Continue Learning: DDL - Data Definition Language


        

Comments

Popular Posts