Each row represents a table constraint of type CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY.
Table 89. SYSCAT.TABCONST Catalog View
Column Name |
Data Type |
Nullable |
Description |
|---|---|---|---|
CONSTNAME |
VARCHAR(18) |
|
Name of the constraint (unique within a table). |
| TABSCHEMA | CHAR(8) |
| Qualified name of the table to which this constraint applies. |
| TABNAME | VARCHAR(18) |
| |
DEFINER |
CHAR(8) |
|
Authorization ID under which the constraint was defined. |
TYPE |
CHAR(1) |
|
Indicates the constraint type: K=CHECK P=PRIMARY KEY F=FOREIGN KEY U=UNIQUE |
REMARKS |
VARCHAR(254) |
Yes |
User-supplied comment, or null. |