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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-25
TEXT Table
Grant information for individual columns is stored separately in the COL_PRIVILEGES
table.
All character columns store letters in uppercase except for GRANTOR and GRANTEE.
TEXT Table
TEXT is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that stores
text for objects in the catalog:
The TEXT table stores text for objects in the catalog such as check constraint text,
view text, or the Java signature of stored procedures in Java (SPJ). The text is stored
in increments of up to 3000 bytes. Text with more than 3000 bytes has multiple entries,
ordered as indicated by the SEQUENCE_NUM column.
TRIGGERS Table
TRIGGERS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
describes triggers:
*6 PRIVILEGE_TYPE CHAR(2) Privilege type:
S SELECT
I INSERT
D DELETE
U UPDATE
R REFERENCES
7 IS_GRANTABLE CHAR(2) Y if granted with grant option
N if not
* Indicates primary key
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID for object.
*2 OBJECT_SUB_ID INT Value to differentiate between text items
associated with the same object
*3 SEQUENCE_NUM INT 0 if part 1 of text, 1 if part 2 of text, 2 if part
3, and so on
4 TEXT VARCHAR (3000) Text associated with object.
* Indicates primary key
Column Name Data Type Description
*1 TRIGGER_UID LARGEINT UID of trigger object
2 SUBJECT_CATALOG_UID LARGEINT UID of the catalog of the subject
table
3 SUBJECT_SCHEMA_UID LARGEINT UID of the schema of the subject
table
* Indicates primary key
Column Name Data Type Description