Selecting primary key columns

Use the Primary Key Editor to select primary key columns for a table. You can also set the order of the key columns.

1. In the Directory Explorer, expand the Optim Primary Keys node and double-click the relationship to edit.
   The Primary Key Editor opens.
2. In the Available columns list, select the key columns.
3. Click >> to move the columns to the Key columns list.

   To set the order of the key columns:

   1. In the Key columns list, select a column to move.
   2. Click Move Up to move a column up in the order, or Move Down to move a column down in the order.
4. Save the primary key.