What is the difference between DDL, DML, DCL and TCL?

SQL and database basics · Freshers

Model answer

DDL (data definition): CREATE, ALTER, DROP. DML (data manipulation): SELECT, INSERT, UPDATE, DELETE. DCL (data control): GRANT, REVOKE. TCL (transaction control): COMMIT, ROLLBACK, SAVEPOINT. Some people count SELECT separately as DQL.

Learn this topic

What Is SQL and What Is a Database? in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions