Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier of the table. |
CONSTRAINT_TYPE
|
CHAR(20)
|
One of:
"PRIMARY KEY"
"UNIQUE"
"FOREIGN KEY"
"INDEX"
"INDEX UNIQUE"
"INTERNAL KEY"
"CHECK". |
CONSTRAINT_SYSID
|
INTEGER
|
System identifier of the constraint. |
CONSTRAINT_KEYCOLS
|
INTEGER
|
Number of key columns in the constraint. |
CONSTRAINT_KEYLEN
|
INTEGER
|
Record length for key columns in the constraint. |
CONSTRAINT_RECCOLS
|
INTEGER
|
Number of columns in constraint. |
CONSTRAINT_RECLEN
|
INTEGER
|
Record length for constraint. |
CONSTRAINT_CARD
|
BIGINT
|
Number of records in constraint. |
DATABANK_SYSID
|
INTEGER
|
System identifier of the databank in which the table is stored. |
IS_CONSISTENT
|
CHAR(3)
|
One of:
"NO" = The index may be inconsistent and should be used for index lookup only
"YES" = The index may be used for index lookup only. |
IS_DEFERRABLE
|
CHAR(3)
|
One of:
"NO" = The constraint is not deferrable
"YES" = The constraint is deferrable. |
INITIALLY_DEFERRED
|
CHAR(3)
|
One of:
"NO" = The constraint is immediate
"YES" = The constraint is not immediate. |
