Data Definition Language (DDL)

Data Definition Language (DDL)

Data Definition Language (DDL)   

We specify the database schema (Data fields , Data Types , Constraints) by a set of definition expressed by a language called DDL.

Example: CREATE TABLE student(SNAME  CHAR(10), ROLLNO CHAR(10)).

This DDL statement creates a table student with fields SNAME and ROLLNO.This information (meta data) is stored in the data dictionary.