Lineage Viewer

The Lineage Viewer displays a hierarchical view of all dependent views and tables for the selected view. The Lineage Viewer shows how the view was derived. The Lineage Viewer has two components:

The navigator is a hierarchical tree; the root node is the selected view. The child nodes are the dependent views, which themselves may have dependent views, etc. If a view depends on a table, the table is displayed as leaf node (that is, the node cannot be expanded).

The component on the right displays the details of the view selected in the navigator. Details include the name of the view and the SQL query whose output defines the view. If you select a table in the navigator pane, the table name is all that is displayed as details.