SYS_VIEW_USAGE

Information on the tables and columns used by views and temporary views.

Column name	Data type	Contents
VIEW_SCHEMA	CHAR (31)	Name of the schema to which the view belongs
VIEW_NAME	CHAR (31)	Name of the view
TABLE_SCHEMA	CHAR (31)	Name of the schema to which the table or column used by the view belongs
TABLE_NAME	CHAR (31)	Name of the table used in the view or to which the column belongs
COLUMN_NAME	CHAR (31)	Name of the table column used in the view Blanks if information on the table
OBJECT_INDICATOR	CHAR (1)	T Row contains information on table C Row contains information on column
VIEW_COLUMN	CHAR (31)	Name of the view column, if the view is updatable, OBJECT_INDICATOR has the value C and the view column is derived from a table column (in COLUMN_NAME) NULL value in all other cases

Table 140: SYS_VIEW_USAGE view of the SYS_INFO_SCHEMA