SQL Reference

SYSCAT.TABCONST

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:

F = FOREIGN KEY

K = CHECK

P = PRIMARY KEY

U = UNIQUE

REMARKS VARCHAR(254) Yes User-supplied comment, or null.


[ Top of Page | Previous Page | Next Page ]