Introduction to DML, DDL, DCL and TCL –

DDL

DDL (Data Definition Language). It is used to create and modify the structure of database objects in database.

Examples: CREATE, ALTER, DROP Table or database statements.

DML

DML(Data Manipulation Language). It is used to retrieve, store, modify, delete, insert and update data in  table database.

Examples: SELECT, UPDATE, INSERT statements.

TCL

TCL(Transactional Control Language). It is used to manage different transactions occurring within a database.

Examples: COMMIT, ROLLBACK statements.

DCL

DCL(Data Control Language). It is used to create roles, permissions,  to control access to database by securing it.

Examples: GRANT, REVOKE statements