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

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-23
OBJECTS Table
OBJECTS Table
OBJECTS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
describes tables, views, indexes, constraints, triggers, MP aliases, stored procedures,
locks, and trigger temporary tables.
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of table; link to OBJECTS
2 MPPARTITION_NAME CHAR(36) Name of NonStop SQL/MP partition
system.volume.subvolume.name
* Indicates primary key
Column Name Data Type Description
*1 SCHEMA_UID LARGEINT UID of schema; link to SCHEMATA
*2 OBJECT_NAME CHAR(128) Simple object name
*3 OBJECT_NAME_SPACE CHAR(2) Object namespace:
CN Constraint
IX Index
LK Lock
TA Table value object (table, view,
stored procedure, SQL/MP alias)
TR Trigger
TT Trigger temp 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 Version of object