DDL vs DML vs DCL

DDL(Data Definition Language)

Statements are used to define the schema

No Rollback

Doesn't make entries in Log File

Auto Commit

Triggers are not fired

·         CREATE

·         ALTER

·         DROP

·         TRUNCATE

·         COMMENT

·         RENAME

DML(Data Manipulation Language)

Statements are used to manage the data within the schema

Can Rollback

Make entries in Log File

No Auto Commit

Triggers are fired

·         SELECT

·         INSERT

·         UPDATE

·         DELETE

·         MERGE

·         CALL

·         EXPLAIN PLAIN

·         LOCK TABLE

DCL(Data Control Language)

·         GRANT

·         REVOKE

TCL(Transaction control Language)

These are used to manage the changes made by DML Statements. It allows statements to be grouped together into logical transactions

·         COMMIT

·         SAVEPOINT

·         ROLLBACK

·         SET TRANSACTION