Page History
...
Displaying or Hiding Table Columns and Indexes
...
Click the Detail/Summary switch to display or hide details of the table display, including table columns and indexes.
Only fields that are used in the WHERE clause are displayed in detail mode. For information on interpreting the icons used in Detail mode, activate the Diagram Legend.
Tip |
---|
You can also switch between Summary Mode and Detail Mode for a specific table or view by double-clicking the object name. |
Note |
---|
You can move tables in the diagram by clicking and dragging them to the desired location. The position of the connecting lines is automatically adjusted. |
Viewing All Fields in a Table
test
Viewing Object SQL
test
Viewing Relationships
Hover the mouse over the table name to view all fields in the table in a pop-up window.
The following illustration shows the pop-up window that appears when hovering over the table.
Viewing Object SQL
Hovering the mouse over the table name, field, or index displays the SQL required to create that object.
Viewing Relationships
Hovering over the join between two tables displays the relationship between the two tables.
test
Expanding Views in the VST Diagram
test
Finding Problematic SQL or Schema
For example, the following is the default layout from query join table CLIENT (c) to view TRANSACTIONS (t).
Right-click on the view, and then choose Expand View.
Now you can see the objects in the view.
test