Difference Between Data Definition Language ,Data Manipulation Language ,Data Control Language and Transaction Control Language in Tabular Form
| Sno. | Basic Terms | DDL | DML | DCL | TCL |
| 1. | Full Form | Data Definition Language | Data Manipulation Language | Data Control Language | Transaction Control Language |
| 2. | Used in | SQL (RDBMS) | SQL (RDBMS) | SQL (RDBMS) | SQL (RDBMS) |
| 3. | Commands | CREATE, DROP, ALTER, TRUNCATE, COMMENT ,RENAME | SELECT, INSERT, UPDATE, DELETE,MERGE,CALL | REVOKE,GRANT | COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION |
| 4. | Definition | Its defines the database structure or database schema. | DML statements are used for managing data with in schema objects. | A Data Control Language is a syntax similar to a computer programming language used to control access to data stored in a database (Authorization). | Its is used to manage transactions in the database.These are used to manage the changes made by DML-statements. It also allows statements to be grouped together into logical transactions. |
| 5. | Classification | None | Procedural and Non-Procedural DMLs. | None | None |
(Visited 10,702 times, 1 visits today)
Written by: