SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-35
VWS Table
The primary key consists of the columns in the following order:
1. USED_OBJECT_UID
2. USED_COL_NUM
3. OPERATION
4. IS_SUBJECT_TABLE
5. TRIGGER_UID
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.
Location for views is stored separately in the REPLICAS table.
*6 OPERATION CHAR(2) Operation that fires the trigger
U UPDATE
I INSERT
D DELETE
For the used-object only, the
operation performed on the used
object
S SELECT
R ROUTINE
*7 IS_SUBJECT_TABLE CHAR(2) Y if the USED_OBJECT_UID is the
subject table of this trigger
N if the USED_OBJECT_UID is
used only by this trigger
* Indicates primary key
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
5 SIMILARITY_CHECK CHAR(2) Y if Similarity Check is enabled
N if not
* Indicates primary key
Column Name Data Type Description