SQL

DML (Data Manipulation Language)

DML commands are used for storing, retrieving, modifying, and deleting data.

SELECT - retrieve data from a database

INSERT - insert data into a database

UPDATE - updates existing data within a database

DELETE - delete records from a database

DDL commands are used for creating, modifying, and dropping the structure of database objects.

CREATE - create database objects such as tables and views

ALTER - alters the structure of the existing database

DROP - delete objects from the database

TRUNCATE - delete all rows from the database

DCL commands are used to implement access control on database objects.

GRANT - give a user access privileges on database objects

REVOKE - withdraw user privileges that were previously given using GRANT