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

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.

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