ROUTINE_COLUMN_USAGE

Information on the routines (procedures and UDFs) that reference columns belonging to the current authorization identifier, as well as the names of the columns.

Column name	Data type	Contents
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
ROUTINE_CATALOG	CHAR(18)	Database name
ROUTINE_SCHEMA	CHAR(31)	Name of the schema to which the routine belongs
ROUTINE_NAME	CHAR(31)	Name of the routine.
TABLE_CATALOG	CHAR(18)	Database name
TABLE_SCHEMA	CHAR(31)	Name of the schema to which the table which is addressed in the routine belongs
TABLE_NAME	CHAR(31)	Name of the table used in the routine
COLUMN_NAME	CHAR(31)	Column name

Table 84: ROUTINE_COLUMN_USAGE view of the INFORMATION_SCHEMA