Structured Query Language: DDL Commands

This is the definition level language which includes the following statements.

A) CREATE Statement
B) ALTER Statement
C) DROP Statement
D) TRUNCATE Statement

A) CREATE Statement: This Statement is used for creating the database and its objects (Tables,Views,Indexes,User Defined Stored Procedures,User Defined Functions,Triggers,Rules,Defaults)

B) ALTER Statement: This Statement is used for modifying the database and its objects (Tables,Views,Indexes,User Defined Stored Procedures,User Defined Functions,Triggers,Rules,Defaults)

C) DROP Statement: This Statement is used for deleting the database and its objects (Tables,Views,Indexes,User Defined Stored Procedures,User Defined Functions,Triggers,Rules,Defaults)

D) TRUNCATE Statement: This Statement is used to delete the data available in a table in Row-By-Row manner but with out disturbing its structure(columns).

Data Definition Language