12. Designing Tables

This chapter explains items that should be examined during table design.

This chapter contains the following sections:

Organization of this chapter
12.1 Items to be examined during table design
12.2 Normalizing a table
12.3 Table row partitioning
12.4 Table matrix partitioning
12.5 Defining a trigger
12.6 Creating a view table
12.7 Specifying the FIX attribute
12.8 Specifying a primary key
12.9 Specifying a cluster key
12.10 Specifying the suppress option
12.11 Specifying the no-split option
12.12 Specifying a binary data column
12.13 Specifying a character set
12.14 Specifying the WITHOUT ROLLBACK option
12.15 Specifying the falsification prevention facility
12.16 Table containing a repetition column
12.17 Table containing an abstract data type
12.18 Shared tables
12.19 Referential constraints
12.20 Check constraints
12.21 Compressed tables
12.22 Temporary tables