In the Design Editor, you can display the relations between the individual tables. To facilitate this, DatabaseSpy provides an option in the context menu that automatically adds referenced or referencing tables to the active design. You can also save this design in a design file.
You can also define to highlight objects that form part of the currently selected relation in the Design Editor options. In this case, as depicted in the screenshot above, tables that are not part of the selected relation are grayed out. Also note that the referenced columns are printed bold in both tables so that you can view at a glance which columns are related with each other.
To display related tables in the Design Editor:
1.Right-click a table in the Design Editor and select AddRelated tables from the context menu.
2.Choose one of the following options from the sub-menu:
To highlight objects of the currently selected relation:
1.Make sure that the Highlight active relations objects check box is activated in the Design Editor options.
2.Click on a connection line. The connection line is highlighted and all tables that are not part of this relation are grayed out in the Design Editor window.