Select a Table for the Primary Key Definition Dialog

The Select a Table for the Primary Key Definition dialog provides a list of database tables for each DB Alias:

select a table for the primary key definition panel, described below

Qualifiers

Identify a database table, view, alias, or synonym by the following qualifiers:

Type
Type of object: table, view, alias, or synonym.
DBMS Type
Type of DBMS to which the selected table is defined.
DB Alias
Alias name to identify the database where the table resides.
Creator ID
Creator ID assigned to the table.
Note: The DB Alias and the Creator ID qualify the table name.
Table Name
Indicates the name assigned to a table.

Pattern

Use a Pattern to limit the list of database tables in the Select a Table for the Primary Key Definition dialog. After you specify a pattern, click Refresh to redisplay the list based on your criteria. See
Use a Pattern for more information.

Primary Keys

After you select a table, the database is checked to determine whether a primary key is defined for that table and attempts to populate the Primary Key Editor with meaningful information:

Note: You can create and modify primary keys defined in the Optim Directory. However, if you have authority, you can use the Create command available from the Utilities menu to create or drop primary keys defined in the database. For more information about the Create Utility, see Create.