SQL: Types of SQL commands

SQL Commands:

SQL commands are instructions. It is used to communicate with the database.

It is also used to perform specific tasks, functions, and queries of data.

SQL can perform various tasks like create a table, add data to tables,

drop the table, modify the table, set permission for users.

Types of SQL Commands

There are five types of SQL commands: DDL, DML, DCL, TCL, and DQL.

DDL (DATA DEFINITION LANGUAGE ) :

create

drop

alter

truncate

DML (DATA MANIPULATION LANGUAGE ) :

insert

update

delete

DCL (DATA CONTROL LANGUAGE):

grant

revoke

TCL (Transaction Control Language):

commit

rollback

DQL (Data Query Language):

SELECT