Chapter 3 Building Physical Diagrams

Tables (PDM)

A table represents a collection of data arranged in columns and rows. Tables may contain any of the following objects:

Columns are named properties of a table that describe its characteristics (see Columns (PDM)).
Indexes are data structures associated with a table that are logically ordered by key values (see Indexes (PDM)).
Keys are columns, or combinations of columns, that uniquely identify rows in a table. Each key can generate a unique index or a unique constraint in a target database (see Keys (PDM)).
Triggers are segments of SQL code associated with tables, and stored in a database. They are invoked automatically whenever there is an attempt to modify data in associated tables (see the Building Triggers and Procedures chapter).

You can use database-specific physical options to specify physical parameters for tables and many other objects (see Physical Options).