Manualshelf

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

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series
1131113211331134113511361137113811391140
Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-36
VW_TBL_USAGE Table
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:
*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
Column Name Data Type Description