Edit-DB Edit-DB
(c) Nigel Maddocks, 2007
Edit-DB ver 2.05.016, Doc ver 2.05.016

7. Relationships

To display information on Relationships between tables and columns, first select Tables from Object type in the Object-Type frame, having ensured that the other selections to the left, labelled Database or Schema (and Owner depending on database type), are completed.

This results in a list of tables in the Object-List frame. Bring up the context menu by right-clicking the desired table. A table's context menu Clicking on a Relations leads to a listing of that table's foreign key relationships, and a listing of tables where the selected table is being used for another table's foreign key(s).

Each listed table is also clickable so that its relationships can be viewed.

Relationships

For Firefox versions 1.5 and above and Internet Explorer with the Adobe SVG Viewer plug-in installed, the listed relationships are also displayed graphically using Scalable Vector Graphics (SVG).

Relationships SVG