What are DDL , DML, DCL and TCL ? — Parv The IT Geek

These are used to create and manage the structure of objects within a database. For example, CREATE, DROP, ALTER commands ON tables, views, indexes, keys…

DML — Data Manipulation Language

These are the commands used to actually query, modify and delete data within a database. For example SELECT, INSERT, UPDATE, DELETE.

DCL — Data Control Language

These are used to control access to databases and objects. For example GRANT, REVOKE, DENY

TCL — Transactional Control Language

These are used to control data modifications made my transactions. For example ROLLBACK TRANSACTION, BEGIN TRANSACTION, COMMIT TRANSACTION


Originally published at https://parvtheitgeek.com on January 10, 2014.

Published by Parvinder Nijjar

I blog at ParvTheITGeek.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

<span>%d</span> bloggers like this: