Difference between DDL DML and DCL
DDL vs DML vs DCL:
| DDL | DML | DCL |
|---|---|---|
| 1. DDL stands for Data Definition Language | 1. DDL stands for Data Manipulation Language | 1. DDL stands for Data Control Language |
| 2. It defines the database structure or schema. | 2. It is used to modify or manipulate the data in the database. | 2. It is used to control the access to the data in the database. |
| 3. DDL commands are - CREATE, DROP, ALTER, TRUNCATE, COMMENT ,RENAME | 3. DDL commands are - SELECT, INSERT, UPDATE, DELETE, MERGE, CALL | 3. DDL commands are - REVOKE, GRANT |