DB2 10.5 for Linux, UNIX, and Windows

Database objects

Physical database design consists of defining database objects and their relationships.

You can create the following database objects in a DB2® database:

Tables
Constraints
Indexes
Triggers
Sequences
Views
Usage lists

You ca use Data Definition Language (DDL) statements or tools such as IBM® Data Studio to create these database objects. The DDL statements 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.