The Tree View displays the successive levels of views that have been composed to construct this view.
To open this dialog, double-click on the view in the Server Explorer and click .
The available options in this dialog are:
Click on any view to open its schema.
Click on the tree nodes representing combining operations (joins, unions, selections, etc.) to display their main properties. For example, for selection operations, it will display their select condition.
Click on a data source (leaf nodes) to see its properties (only in administration mode) Sensitive information such as passwords is not displayed.
Click Save image to export the Tree View to a file (a PNG file).
You can obtain programatically, the same information displayed in this dialog, with the stored procedure VIEW_DEPENDENCIES.
SELECT * FROM view_dependencies() WHERE input_view_database_name = 'sales_reporting' AND input_view_name = 'order';