Finding Related Tables

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exploring and Changing the Database Structure > Viewing Table Structure >

Finding Related Tables

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.

design_relations

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:

 

Referenced Tables
Referencing Tables
All Relations

 

 

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.

© 2019 Altova GmbH