SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-27
VWS Table
VWS Table
VWS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that lists
views in the catalog:
Text for views is stored separately in the TEXT table on the master node for the
catalog.
Location for views is stored separately in the REPLICAS table.
VW_COL_TBLS Table
VW_COL_TBLS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that records the base table (but not the columns) referenced by each column of a view
in the catalog:
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of view
2 CHECK_OPTION CHAR(2) C if CASCADE
L if LOCAL
N if None
3 IS_UPDATABLE CHAR(2) Y if updating allowed
N if not
4 IS_INSERTABLE CHAR(2) Y if inserting allowed
N if not
* Indicates primary key
Column Name Data Type Description
*1 VIEW_UID LARGEINT UID of referencing view
*2 VIEW_COL_NUM INT Column number of referencing column
(first is 0)
*3 UNDERLYING_CAT_UID LARGEINT UID of catalog of referenced table
*4 UNDERLYING_SCH_UID LARGEINT UID of schema of referenced table
*5 UNDERLYING_OBJ_UID LARGEINT UID of referenced table
* Indicates primary key