Yet another blog

Tag Archives: data manipulation language

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