Data Definition Language (DDL)

• Specification notation for significant the database schema

Example: create table account (

Account number char (10),

Balance integer)

DDL compiler produces a set of tables stored in a data dictionary.

1. Data dictionary contains metadata (i.e., data about data)
2. Database schema
3. Data storage and definition language
4. Specifies the storage structure and admittance methods used

Integrity constraints

Domain constraints

Referential integrity (references constraint in SQL)

Assertions

Authorization