SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-29
VW_COL_TBL_COLS Table
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:
VW_TBL_USAGE Table
VW_TBL_USAGE is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that records references by views in the catalog to tables or other 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
*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
*4 USED_OBJ_UID LARGEINT UID of object with referenced column
*5 COLUMN_NUMBER INT Column number within object (first is 0)
* Indicates primary key
Column Name Data Type Description
*1 USING_VIEW_UID LARGEINT UID of referencing view
*2 USED_OBJ_UID LARGEINT UID of referenced object
*3 VIEW_CATALOG_UID LARGEINT UID of catalog of referencing view
*4 USED_OBJ_CATALOG_UID LARGEINT UID of catalog of referenced object
5 VIEW_SCHEMA_UID LARGEINT UID of schema of referencing view
6 USED_OBJ_SCHEMA_UID LARGEINT UID of schema of referenced object
* Indicates primary key