VIEW_TABLES System Table Description

Description

A cross-reference of views and tables in the database. Each row in SYSTEM.VIEW_TABLES references a table used in a view definition. Each view may have one or more entries in the SYSTEM.VIEW_TABLES table.

Fields

Field Type Description
VIEWNAME string Name of the view
VIEWSCHEMA string Schema containing the view
SEQUENCE integer The number (0-indexed) of the table as it is referenced in the view definition. So if a view definition references tables A,B, and C as in "from A, B, C", then the entry for A in VIEW_TABLES will have SEQUENCE==0, B will have SEQUENCE==1, and C will have SEQUENCE==2.
TABLENAME string Table used in definition of the view; there may be multiple rows per view with different or same values of TABLENAME.
SCHEMA string Schema containing the table used in the definition of the view.

Indexes

Primary Index: VIEW_TABLES..PRIMARY_KEY on fields: VIEWSCHEMA, VIEWNAME, SEQUENCE