PradysTechBlog

Yet another blog

What is a DDL, DML and DCL

The Data Definition Language (DDL) is used to create and destroy databases and database objects. These commands will primarily be used by database administrators during the setup and removal phases of a database project. Let’s take a look at the structure and usage of four basic DDL commands:

  1. Create
  2. Drop
  3. Alter
  4. Use

The Data Manipulation Language (DML) is used to retrieve, insert and modify database information. These commands will be used by all database users during the routine operation of the database. The Basic DML commands are

  1. Select
  2. Insert
  3. Delete
  4. Update

The Data Control Language (DCL) is used to  control your  DML and DDL statements so that your data is protected and has consistency. The Basic DCL commands are

  1. Grant
  2. Revoke
Advertisements

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

%d bloggers like this: