Difference Between Data Definition Language ,Data Manipulation Language ,Data Control Language and Transaction Control Language in Tabular Form

Sno.Basic TermsDDLDMLDCLTCL
1.Full FormData Definition LanguageData Manipulation LanguageData Control LanguageTransaction Control Language
2.Used inSQL (RDBMS)SQL (RDBMS)SQL (RDBMS)SQL (RDBMS)
3.CommandsCREATE, DROP,
ALTER, TRUNCATE, COMMENT
,RENAME
SELECT, INSERT, UPDATE,
DELETE,MERGE,CALL
REVOKE,GRANTCOMMIT, ROLLBACK,
SAVEPOINT, SET TRANSACTION
4.DefinitionIts  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.ClassificationNoneProcedural and Non-Procedural
DMLs.
NoneNone
(Visited 161 times, 1 visits today)

Written by:

Leave a Reply

Your email address will not be published. Required fields are marked *