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

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-29
TBL_CONSTRAINTS Table
Each SG_USAGE row links a base table with an IDENTITY column to the associated
internal Sequence Generator.
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:
5 SG_SCH_UID LARGEINT Schema UID of used SG
object
6 USING_OBJECT_SC
H_UID
LARGEINT Schema UID of using
object
* Indicates primary key
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