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.

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?

Can you answer this question?

1 Answers