VIEW_TABLES
Shows details about view-related dependencies, including the table that reference a view, its schema, and owner.
| Column Name | Data Type | Description |
|---|---|---|
TABLE_ID
|
INTEGER
|
Catalog-assigned integer value that uniquely identifies the view. |
TABLE_SCHEMA
|
VARCHAR
|
Name of the view schema. |
TABLE_NAME
|
VARCHAR
|
Name of the view. |
REFERENCE_TABLE_ID
|
INTEGER
|
Catalog-assigned integer value that uniquely identifies the view's source table. |
REFERENCE_TABLE_SCHEMA
|
VARCHAR
|
Name of the view's source table schema. |
REFERENCE_TABLE_NAME
|
VARCHAR
|
Name of the view's source table. |
REFERENCE_TABLE_OWNER_ID
|
INTEGER
|
Catalog-assigned integer value that uniquely identifies the view owner. |