SQL Reference

SYSCAT.TABCONST

Each row represents a table constraint of type CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY.

Table 86. 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.

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 | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]