Categories of Sql Commands

Introduction

SQL is a standard language for relation database management system (RDBMS), which used to communicate with a database. This communication made by the different commands. These commands are different in kind. In the given below figure show the basic categories of SQL commands.


command types in SQL DataBase

Explain

  • DDL ( Data Definition Language )

    In this category, commands are used to create and modify database objects in the database. Such as create table, drop table , change table name and fields.
     
  • DML ( Data Manipulation Language )

    In this category, commands are used to manipulate data. Such as select, update, insert, modify and delete data in the database.
     
  • DCL ( Data Control Language )

    In this category, commands are used to authentication and authorization permission. Such as create user role, permission and referential integrity.
     
  • TCL (  Transactional Control Language )

    In this category, commands are used to manage different logical transactions in the database. Such as commit and rollback  statement.
Ebook Download
View all
Learn
View all