Vertica Analytics Platform Version 9.2.x Documentation

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.