VIEW_COLUMN_USAGE
The VIEW_COLUMN_USAGE system view lists the table columns on which views that are owned by the current ident depend.
Column name
|
Data type
|
Description
|
| VIEW_CATALOG |
VARCHAR(128) |
The name of the catalog containing the view. |
| VIEW_SCHEMA |
VARCHAR(128) |
The name of the schema containing the view. |
| VIEW_NAME |
VARCHAR(128) |
The name of the view. |
| TABLE_CATALOG |
VARCHAR(128) |
The name of the catalog containing the table. |
| TABLE_SCHEMA |
VARCHAR(128) |
The name of the schema containing the table. |
| TABLE_NAME |
VARCHAR(128) |
The name of the table. |
| COLUMN_NAME |
VARCHAR(128) |
The name of the column. |