<< Click to Display Table of Contents >>

Working with diagram subsets

Top Previous Next

After scanning a complete database schema, you will be shown a large entity/relationship diagram with many tables and relationships. A very small zoom factor is required to see all the tables at once. The screen resolution will probably be insufficient to make that view readable. You can print it on poster-size sheets and wallpaper your office. Or you can define workable subsets of the entire diagram.

There are two predefined subsets:

Entire diagram

Remaining tables, i.e. collection of all tables that are not member of any other true subset.

Click the Subset | New menu item to define a new subset. You will then be prompted to enter a unique name for the new subset.



The box on the left shows all available tables that could be included in the diagram. The box on the right lists all tables that have already been selected to become members of the subset. Use the buttons between the list boxes to move table names between them:

Include Selection moves all selected tables to the list of tables in the subset.

Include Subtree selects the current table including all parent and child tables up to the specified levels.

Exclude Selection removes all selected tables from the list of tables in the subset.

Although you can move tables between the two list boxes as described above, the buttons below the boxes also allow you to:

Select all tables having a foreign-key reference to any other table or referenced by a foreign key.

Select all tables without foreign-key relationships

Select all independent tables, i.e. tables not pointed to by foreign keys.

Invert selection, i.e. select unselected and unselect selected tables.

Select all tables

Unselect all tables