view_table_usage

The view_table_usage view provides information about tables 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 used by the view.
table_schema sql_identifier The name of the schema containing the table used by the view.
table_name sql_identifier The name of the table used by the view.