VIEW_TABLE_USAGE

Information on the tables that belong to the current authorization identifier and on which view are based.

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

Table 106: VIEW_TABLE_USAGE view of the INFORMATION_SCHEMA