Specifications

Working with keys
98 InfoMaker
• Open the table containing the primary key used by a particular foreign key
• Create, alter, and drop keys
For the most part, you work with keys the same way for each DBMS that
supports keys, but there are some DBMS-specific issues. For complete
information about using keys with your DBMS, see your DBMS
documentation.
Viewing keys
Keys can be viewed in several ways:
• In the expanded tree view of a table in the Objects view
• As icons connected by lines to a table in the Object Layout view
In the following picture, the Department table has two keys:
• A primary key (on
dept_id)
• A foreign key (on
dept_head_id)
If you cannot see the lines
If the color of your window background makes it difficult to see the lines for
the keys and indexes, you can set the colors for each component of the
Database painter’s graphical table representation, including keys and indexes.
For information, see “Modifying database preferences” on page 81.
Opening related
tables
When working with tables containing keys, you can easily open related tables.
❖ To open the table that a particular foreign key references:
1 Display the foreign key pop-up menu.
2 Select Open Referenced Table.
❖ To open all tables referencing a particular primary key:
1 Display the primary key pop-up menu.
2 Select Open Dependent Table(s).
InfoMaker opens and expands all tables in the database containing foreign
keys that reference the selected primary key.