What are the 4 types of commands in SQL?

Question

Aryan Kumar · Answer

There are 5 types of SQL commands:
Data Definition Language (DDL): Commands that are used to create, alter, and drop database objects such as tables, views, and stored procedures.Data Manipulation Language (DML): Commands that are used to insert, update, delete, and select data from tables.Data Query Language (DQL): Commands that are used to retrieve data from tables.Transaction Control Language (TCL): Commands that are used to manage transactions, such as starting, committing, and rolling back transactions.Data Control Language (DCL): Commands that are used to manage user access to databases, such as granting and revoking permissions.
Here is a table summarizing the 5 types of SQL commands:
Type
Description
DDL
Used to create, alter, and drop database objects such as tables, views, and stored procedures.
DML
Used to insert, update, delete, and select data from tables.
DQL
Used to retrieve data from tables.
TCL
Used to manage transactions, such as starting, committing, and rolling back transactions.
DCL
Used to manage user access to databases, such as granting and revoking permissions.

forum

What are the 4 types of commands in SQL?

Revati S Misra

Can you answer this question?

1 Answers

Liked By

Type	Description
DDL	Used to create, alter, and drop database objects such as tables, views, and stored procedures.
DML	Used to insert, update, delete, and select data from tables.
DQL	Used to retrieve data from tables.
TCL	Used to manage transactions, such as starting, committing, and rolling back transactions.
DCL	Used to manage user access to databases, such as granting and revoking permissions.