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-23
OBJECTS Table
4 OBJECT_TYPE CHAR(2) Object type:
BT Base table
CC Check constraint
IX Index
LK Lock
MP SQL/MP alias
PV SQL/MP alias to an MP protection
view
SV SQL/MP alias to an MP shorthand
view
NN Not null constraint
PK Primary key constraint
RC Referential constraint
TR Trigger object
UC Unique constraint
UR User-defined routine (for
example, a stored procedure)
VI View
5 OBJECT_UID LARGEINT UID of object
6 CREATE_TIME LARGEINT Julian timestamp of creation time
7 REDEF_TIME LARGEINT Julian timestamp of redefinition time
8 CACHE_TIME LARGEINT Julian timestamp of cache time
9 OBJECT_FEATURE_VERSION INT Feature version of the object.
Starting with SQL/MX Release 3.2, the
value is 3200 for all objects that use
3200 features
10 VALID_DEF CHAR(2) Y if definition valid
N if not
11 OBJECT_SECURITY_CLASS CHAR(2) UM User metadata table
UT User-defined table
SM System metadata table
12 OBJECT_OWNER INT The integer representation of the
owner's authorization ID
13 RESERVED_FILLER_INT INT Reserved for future use
14 RESERVED_FILLER_CHAR CHAR(20) Reserved for future use
15 DROPPABLE CHAR(2) Reserved for future use
16 RCB_VERSION INT The version of the object's Record
Control Block (RCB)
* Indicates primary key
Note. In the definition schema version 3000 and later versions, a unique index called OBJIDX
is defined on the OBJECT_UID column.
Column Name Data Type Description