DB2 Version 9.7 for Linux, UNIX, and Windows

Database objects

Logical database design consists of defining database objects.

The following database objects can be created within a DB2® database:

Tables
Constraints
Indexes
Triggers
Sequences
Views

These database objects can be created using graphical user interfaces or by explicitly executing statements. The statements used to create these database objects are called Data Definition Language (DDL) statements and are generally prefixed by the keywords CREATE or ALTER.

Understanding the features and functionality that each of these database objects provides is important to implement a good database design that meets your current business's data storage needs while remaining flexible enough to accommodate expansion and growth over time.