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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-24
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:
TBL_PRIVILEGES Table
TBL_PRIVILEGES is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that stores grant information for tables in the catalog:
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)
* Indicates primary key
Column Name Data Type Description
*1 GRANTOR INT Security ID of grantor (or of owner if grantor
is the super ID acting for owner)
*2 GRANTOR_TYPE CHAR(2) S if system grant
U if user grant
*3 GRANTEE INT If GRANTEE_TYPE is U, security ID of
grantee and link to COL_PRIVILEGES; no
meaning otherwise
*4 GRANTEE_TYPE CHAR(2) P if public grant
U if user grant
*5 TABLE_UID LARGEINT UID of table
* Indicates primary key