What are the 5 types of SQL?
What are the 5 types of SQL?
Ask by Utpal Vishwas
Updated 28 Aug 2023
There are 5 types of SQL commands, but let me introduce you to the 4 basic ones:
Data Definition Language (DDL): This type of command is used to create, alter, and drop database objects, such as tables, views, and stored procedures.
Data Manipulation Language (DML): This type of command is used to insert, update, delete, and select data from tables.
Data Query Language (DQL): This type of command is used to retrieve data from tables.
Transaction Control Language (TCL): This type of command is used to manage transactions, such as starting, committing, and rolling back transactions.
The fifth type of SQL command, Data Control Language (DCL), is not as commonly used as the other four. It is used to manage user access to databases, such as granting and revoking permissions.