After you select a table, Optim checks the database and the Optim™ Directory to determine if a primary key is defined for the selected table and lists columns in the Primary Key Editor:
If a generic primary key applies to the table, the Creator ID of the base table is displayed. If you select an explicit primary key, the box is blank and protected.
Description of the content or purpose of the Optim primary key (up to 40 characters). You can modify this description for primary keys.
List of columns in the primary key, in priority order.
To create or modify a primary key, drag column names between the Available Columns box and the Key Columns box. You can also drag column names to arrange the Key Columns in priority order. You cannot create a Primary Key using an SQL Variant column.
To remove columns from the Key Columns box, right-click to open a shortcut menu and select Remove or Remove All. You can also drag column names from the Key Columns box to the Available Columns box.
Columns that are available to be included in the primary key. Columns currently included in the primary key are not listed. Initially, the columns are listed in the order that they are defined in the database.
In addition to the standard File, Edit, and Tools menu commands, you can select the following commands from the Tools menu in the Primary Key Editor: