Relational Navigation View

The Relational Navigation View displays the information in the database using a familiar tree model. The top-level lists the objects in the database including tables, views, queries and stored procedures. Only items for which the user has at least read priviliges or execute privileges for stored procedures will be available. 

For row returning objects you can click the plus sign to view the row caption of each row.  If the base table of the row is the target of a non-dependent foreign key you can continue to drill-down through the related rows.

Clicking the caption of an object takes you to the List view of the object.  For procedures that do not return rows or take parameters, clicking the caption will execute the procedure.

Hovering the mouse over the caption of a database object will display a tool-tip that contains the description.

Certain database objects will not be displayed at the top-level of the Relational Navigation View.

• Hidden objects are not displayed at the top-level of the Relational Navigation View. You can hide objects using the Gatsby Design Assistant.  Hidden objects may still be visible at a lower level of the tree if they participate in a relationship with an item that is displayed.
• Dependent views are not displayed in the Relational Navigation View. A view (table, view or select-only query) is dependent if it is on the "Many" end of a dependent relationship. These kinds of views are considered weak and therefore not shown in the Relational Navigation View. Instead, they appear as sub-forms on the corresponding strong table form. For one-to-one, dependent relationships the related view appears as a set of grouped fields on the corresponding strong table from.

List View