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.

To select primary key columns for a table:

  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.


Feedback