The Select a Table for the Primary Key Definition dialog
provides a list of database tables for each DB Alias:
- The
DB Aliases that correspond to the available databases are listed on
the left. The selected DB Alias is shaded. To change the selection,
double-click a different DB Alias or overtype the DB Alias in the Pattern box.
(If you change this selection in either place, it automatically changes
in the other.)
- The type of object (table, view, alias, synonym)
and fully qualified table names appear in the right list box. The
list is sorted in alphabetical order by Creator ID and table name.
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:
- If the database contains a primary key for the selected
table, the details are shown in the Primary Key Editor. You cannot
modify or delete a primary key defined in the database. However, you
can display the primary key information in the Primary Key Editor.
- If the database does not contain a primary key for
the selected table, the Optim Directory
is checked. If an Optim primary
key exists, the details are shown in the Primary Key Editor. You can
browse, modify, or delete a primary key.
- If neither the database nor the Optim Directory contains a primary key for
the selected table, the table and its columns are shown in the Primary
Key Editor. You can create a primary key.
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.