4. Unique constraints (Create Table)
The Unique Constraints panel is displayed if you select Table Creation option 4 (Unique Constraints) on the main Create Table panel.
You use the Unique Constraints panel to specify information to define a primary key and up to three additional unique keys for the table you are creating. The panel shows only those columns that are defined as NOT NULL (and therefore eligible to be selected as part of either the primary key or a unique key).
To define the primary key or any of the three unique keys, enter S or
a number in one of the Column Order in Key fields to add a
column to the key. If you enter S, FM/Db2 generates
the next highest number for that key. To deselect a column that is
already selected, clear the displayed number by overtyping it with
spaces.
You can optionally specify constraint names for the primary key and the three unique keys.
Related references