ROUTINE_ROUTINE_USAGE

Information on the routines (procedures and UDFs) that belong to the current authorization identifier and are called in other routines.

Column name	Data type	Contents
SPECIFIC_CATALOG	CHAR(18)	Database name
SPECIFIC_SCHEMA	CHAR(31)	Name of the schema to which the calling routine belongs
SPECIFIC_NAME	CHAR(31)	Specific name of the calling routine
ROUTINE_CATALOG	CHAR(18)	Database name
ROUTINE_SCHEMA	CHAR(31)	Name of the schema to which the called routine belongs
ROUTINE_NAME	CHAR(31)	Specific name of the called routine

Table 86: ROUTINE_ROUTINE_USAGE view of the INFORMATION_SCHEMA