ROUTINE_TABLE_USAGE

Information on the tables that belong to the current authorization identifier and which are addressed in routines (procedures and UDFs).

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

Table 87: View ROUTINE_TABLE_USAGE view of the INFORMATION_SCHEMA