VIEW_ROUTINE_USAGE

Information on the User Defined Functions (UDFs) that belong to the current authorization identifier and are called in views.

Column name	Data type	Contents
TABLE_CATALOG	CHAR(18)	Database name
TABLE_SCHEMA	CHAR(31)	Name of the schema to which the view belongs
TABLE_NAME	CHAR(31)	Name of the view
SPECIFIC_CATALOG	CHAR(18)	Database name
SPECIFIC_SCHEMA	CHAR(31)	Name of the schema to which the routine belongs
SPECIFIC_NAME	CHAR(31)	Specific name of the routine

Table 105: VIEW_ROUTINE_USAGE view of the INFORMATION_SCHEMA