The five types of SQL statements are :
DDL : The Data Definition Language(DDL) helps in the creation of a database structure or schema. CREATE, DROP, ALTER, RENAME, and TRUNCATE are the five types of DDL commands in SQL.
DML : The Data Manipulation Language (DML) allows you to insert, change, and delete data from a database instance. It’s incharge of making all kinds of changes to a database’s data. The database application and the user can insert data and information using three basic commands which are: INSERT, UPDATE, DELETE.
DCL : GRANT and REVOKE are commands in the DCL (Data Control Language) that can be used to grant “rights and permissions.” The database system’s parameters are controlled by other permissions.
TCL : TCL commands, or Transaction Control Language(TCL), deal with database transactions. COMMIT, ROLLBACK, SAVEPOINT are the commands of TCL.
DQL : The data is retrieved from the database using Data Query Language (DQL). It just has one command, which is SELECT
