Explain SQL QUERY COMPONENTS

Explain SQL QUERY COMPONENTS

Components of SQL Query:

DDL (Data Definition Language) :–
It is a set of SQL commands used to create, modify, and delete database structures but not data.
Ex: CREATE, ALTER, DROP

DML (Data Manipulation Language) :–
It is the area of SQL that allows changing data within the database.
Ex: INSERT, UPDATE, DELETE

DCL (Data Control Language) :–
It is the component of SQL statement that control access to data and to the database.
Ex: GRANT, REVOKE, COMMIT, ROLLBACK

Tweet