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