sa_dependent_views system procedure

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

Syntax

sa_dependent_views( 
[ tbl_name 
[, owner_name ] ] 
)

Arguments

tbl_name – Use this optional CHAR(128) parameter to specify the name of the table or view. The default is NULL.
owner_name – Use this optional CHAR(128) parameter to specify the owner for tbl_name. The default is NULL.

Result set

Column name	Data type	Description
table_id	UNSIGNED INTEGER	The object ID of the table or view.
dep_view_id	UNSIGNED INTEGER	The object ID of the dependent views.

Remarks

Use this procedure to obtain the list of IDs of tables and their dependent views.

No errors are generated if no existing tables satisfy the specified criteria for table and owner names. The following conditions also apply:

If both owner and tbl_name are NULL, information is returned on all tables that have dependent views.
If tbl_name is NULL but owner is specified, information is returned on all tables owned by the specified owner.
If tbl_name is specified but owner is NULL, information is returned on any one of the tables with the specified name.

Privileges

None

Side effects

None

Examples

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.

CALL 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;