Tree View¶

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).

Tree view of incidents_sales¶

SELECT DISTINCT dependency_type,
                    dependency_database,
                    dependency_name
FROM GET_PUBLIC_VIEW_DEPENDENCIES()
WHERE input_view_database_name = 'tpc_h'
      AND input_view_name = 'orders_of_european_customers';

SELECT DISTINCT dependency_type,
                dependency_database,
                dependency_name
FROM GET_PUBLIC_VIEW_DEPENDENCIES()
WHERE input_view_database_name = 'tpc_h'
      AND input_view_name = 'orders_of_european_customers'
      AND position('Datasource' IN dependency_type) > 0
      AND depth = 1;