Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

sa_dependent_views system procedure

Returns the list of all dependent views for a given table or view.

sa_dependent_views( 'tbl_name [, owner_name ' )

• tbl_name  Use this CHARACTER parameter to specify the name of the table or view.

• owner_name  Use this optional CHARACTER parameter to specify the owner for tbl_name.

Use this procedure to obtain the list of IDs of dependent views. Alternatively, you can use the procedure in a statement that returns more information about the views, such as their names.

DBA authority required

None

• SYSDEPENDENCY system view
• View dependencies

In this example, the sa_dependent_views system procedure is used to obtain the list of IDs for the views that are dependent on the SalesOrders table. The procedure returns the table_id for SalesOrders, and the dep_view_id for the dependent view, ViewSalesOrders.

sa_dependent_views( 'SalesOrders' );

In this example, the sa_dependent_views system procedure is used in a SELECT statement to obtain the list of names of views dependent on the SalesOrders table. The procedure returns the ViewSalesOrders view.

SELECT t.table_name FROM SYSTAB t,  
sa_dependent_views( 'SalesOrders' ) v 
WHERE t.table_id = v.dep_view_id;