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