DB Cruiser - Table Work Area -- Foreign Keys

DB Cruiser -- Table Work Area -- Foreign Keys:

You can view the foreign key(s) by clicking Foreign Keys button. It displays both Imported (parent) Keys and Exported (child) Keys.

If you want to know information about any imported or exported key, simply click the corresponding PK Table Name or FK Table Name (blue colored), a new window will pop up and display the information about the imported or exported key.

This gives you a convenient way to reveal the parent-child relationship among tables, and an easy way to navigate among tables within the relationship. This is the feature many developers and DBAs want.

For example, the above screen displays both imported and exported keys of MT_UNIT table of the schema SCOTT. If you want to know the imported key (parent key) FK_UNIT8 with column name LOCATION_ID, click the corresponding PK Table Name column, MT_STORAGE, the foreign keys of the parent table MT_STORAGE will be displayed. See here for details.

Similarly, If you want to know the exported key (child key) PK_PROD_DETAIL with column name UNIT_ID, click the corresponding FK Table Name column, MT_UNIT_IMPL, the foreign keys of the parent table MT_UNIT_IMPL will be displayed. See here for details.