SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-35
VW_COL_TBLS 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:
VW_COL_TBL_COLS Table
VW_COL_TBL_COLS is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that records the base table columns
referenced by each column of a view in the catalog:
VW_COL_USAGE Table
VW_COL_USAGE is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that records references in views in the catalog to columns of tables or views:
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
Note. The VW_COL_TBLS table is not present in v3000 and newer definition schemas.
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
*6 UNDERLYING_COL_NUM INT Column number of referenced column
(first is 0)
* Indicates primary key
Column Name Data Type Description
*1 USING_VIEW_UID LARGEINT UID of referencing view
*2 USED_CAT_UID LARGEINT UID of catalog of referenced column
*3 USED_SCH_UID LARGEINT UID of schema of referenced column