Indented Table Display

Select Indent from the Tools menu to view the Indented Table Display dialog. The Indented Table Display dialog has three tabs:

Default Qualifier

Default qualifier specified for the Access Definition.

Indent Tab

View a list of table names in a format that shows the relationships selected in the Access Definition. The rows on the Indent tab are numbered for easy reference.

indent tab display, showing customers table, with these tables indented below it: sales, orders, orders(3)
Table
The names of the tables listed in the Access Definition.
  • The name of each table, except the Start Table, is prefixed with a P (parent table) or a C (child table) to show the relationship to the table under which it is listed.
  • If a table is referenced several times (for example, a child table with three parents), the suffix (n) indicates the line number of the first occurrence.
  • If a table is included in an RI cycle, the suffix (CYCLE:n) indicates the line number of other tables in the cycle.
Relation
Constraint name for the relationship with the table under which the table is listed. The constraint name for the Start Table is shown as Start Table.
Type
The type of relationship as defined in the DBMS or the Optim™ Directory. This grid cell is blank for the Start Table.

Reference Tables Tab

Tables designated as reference tables on the Access Definition Editor Table List. The Reference Tables tab is available only if you designated one or more reference tables.

reference tables tab

Unconnected Tab

Tables on the Access Definition Editor table List that are not related to any other table in the Access Definition. The Unconnected tab is available only if one or more tables in the Access Definition cannot be traversed during a process.

unconnected tab showing these tables:  female_rates and male_rates