Related views

A related view is a view that uses, or is dependent on, another object, such as the parent view or a table.

When you select an object (such as a view or a table) and select Show Related Views, the Show Related Views window opens and lists all the views that are dependent on the object you selected.

Scenario:

The following examples are based on this scenario:

• View 1 is created based on data from Table A.
• View 2 and View 3 are created based on View 1.
• View 4 is created based on View 3.

Examples

If you select Show Related Views for View 1, the Show Related Views window lists the following related views:

• View 2
• View 3

View 4 is not listed because only the first level of dependencies are listed.

If you select Show Related Views on Table A, the following related view is listed:

• View 1

If you select Show Related View for View 3, View 4 is listed in the window.

If you select Show Related Views for View 2 or View 4, the Show Related Views window is empty because no views are dependent on them.