The view_column_usage view provides information about columns used in view definitions.
| Column name | Data type | Description |
|---|---|---|
view_catalog |
sql_identifier |
The name of the current database containing the view. |
view_schema |
sql_identifier |
The name of the schema containing the view. |
view_name |
sql_identifier |
The name of the view. |
table_catalog |
sql_identifier |
The name of the current database containing the table column used by the view. |
table_schema |
sql_identifier |
The name of the schema containing the table column used by the view. |
table_name |
sql_identifier |
The name of the table with a column used by the view. |
column_name |
sql_identifier |
The name of the column used by the view. |