Creating a generic primary key

Use the Primary Key Editor to create a generic Optim™ primary key.

Some databases contain sets of tables that are identical except for the creator ID. Rather than define an explicit primary key for each table, define a generic primary key for all tables that have the same base name, regardless of the creator ID.

To create a generic Optim primary key:

  1. In the Directory Explorer, expand the Optim Primary Keys node and double-click the relationship to edit. The Primary Key Editor opens.
  2. Click Generic.
  3. Save the primary key.


Feedback