Use the Primary Key Editor to select primary key columns
for a table. You can also set the order of the key columns.
To select primary key columns for a table:
- In the Directory Explorer, expand the Optim
Primary Keys node and double-click the relationship to
edit. The Primary Key Editor opens.
- In the Available columns list, select
the key columns.
- Click >> to move the columns to
the Key columns list.
To set
the order of the key columns:
- In the Key columns list, select
a column to move.
- Click Move Up to move a column
up in the order, or Move Down to move a column
down in the order.
- Save the primary key.