VIEW_COLUMN_USAGE

Information on views that reference columns belonging to the current authorization identifier, as well as the names of the corresponding columns.

Column name	Data type	Contents
VIEW_CATALOG	CHAR (18)	Database name
VIEW_SCHEMA	CHAR (31)	Name of the schema to which the view belongs
VIEW_NAME	CHAR (31)	Name of the view
TABLE_CATALOG	CHAR (18)	Database name
TABLE_SCHEMA	CHAR (31)	Name of the schema to which the table that is referenced in the view belongs
TABLE_NAME	CHAR (31)	Name of the table referenced in the view
COLUMN_NAME	CHAR (31)	Column name

Table 104: VIEW_COLUMN_USAGE view of the INFORMATION_SCHEMA