SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-25
REF_CONSTRAINTS Table
All character columns store letters in uppercase except PARTITION_NAME and
FIRST_KEY.
REF_CONSTRAINTS Table
REF_CONSTRAINTS is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that describes referential constraints on
tables in the catalog. It links each referential constraint to a unique constraint for the
referenced table.
12 EOF LARGEINT End of file indication at last
UPDATE STATISTICS
13 PARTITION_STATUS CHAR(2) Status defined by:
AV Available
UO Unavailable, offline
UC Unavailable, corrupt
UD Unavailable, dropped
UR Unavailable, re-created
14 DDL_IN_PROGRESS CHAR(2) Reserved for future use
15 FIRST_KEY VARCHAR(28670) User-specified first key in
normalized form; otherwise,
zero-length. If hash partitioned, a
logical partition number.
16 ENCODED_KEY VARCHAR(2732) Internal encoded value of first
key for the partition
17 PARTITION_DROP_TIME LARGEINT Julian timestamp of when the
partition was dropped.
* Indicates primary key
Column Name Data Type Description
*1 CONSTRAINT_UID LARGEINT UID of constraint, link to
TBL_CONSTRAINTS
2 UNIQUE_CONSTRAINT_CAT_UID LARGEINT UID of catalog with referenced
unique constraint
3 UNIQUE_CONSTRAINT_SCH_UID LARGEINT UID of schema with referenced
unique constraint
4 UNIQUE_CONSTRAINT_UID LARGEINT UID of referenced unique
constraint
5 MATCH_OPTION CHAR(2) Reserved for future use
6 UPDATE_RULE CHAR(2) CA CASCADE
RE RESTRICT
NA NO ACTION
SD SET DEFAULT
SN SET NULL
Column Name Data Type Description