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

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-30
TBL_CONSTRAINTS Table
TBL_CONSTRAINTS Table
TBL_CONSTRAINTS is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that contains one entry for each unique,
primary key, foreign, or check constraint on a table in the catalog:
In version 1200 schemas, the primary key consists of the columns in the following
order:
1. CONSTRAINT_UID
2. CONSTRAINT_TYPE
3. TABLE_UID
In version 3000 and later schemas, the primary key consists of the columns in the
following order:
1. TABLE_UID
2. CONSTRAINT_UID
3. CONSTRAINT_TYPE
Column Name Data Type Description
*1 CONSTRAINT_UID LARGEINT UID of constraint
*2 CONSTRAINT_TYPE CHAR(2) Constraint type:
C Check
F Foreign
P Primary key
U Unique
*3 TABLE_UID LARGEINT UID of table
4 DISABLED CHAR(2) Y if not enforced
N if enforced
5 DROPPABLE CHAR(2) Y if user can drop
N if user cannot drop
6 IS_DEFERRABLE CHAR(2) Reserved for future use
7 INITIALLY_DEFERRABLE CHAR(2) Reserved for future use
8 INDEX_UID LARGEINT If an index supports this constraint, UID
of index; otherwise 0 (zero)
9 ENFORCED CHAR(2) Reserved for future use.
10 VALIDATED CHAR(2) Reserved for future use.
11 LAST_VALIDATED LARGEINT Reserved for future use.
* Indicates primary key