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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-21
REF_CONSTRAINTS Table
All character columns store letters in uppercase except 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
same 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(3000) User-specified first key in
normalized form; otherwise,
zero-length. If hash partitioned, a
logical partition number.
16 ENCODED_KEY VARCHAR(341) Internal encoded value of key
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
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) RE RESTRICT
NA NO ACTION
SD SET DEFAULT
SN SET NULL
* Indicates primary key
Column Name Data Type Description