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-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.
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
7 DELETE_RULE CHAR(2) CA CASCADE
RE RESTRICT
NA NO ACTION
SD SET DEFAULT
SN SET NULL
* Indicates primary key
Column Name Data Type Description