IBM Books

Administration Guide


OBJCAT.TABCONST

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

Table 114. OBJCAT.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 

ORIGIN_TABSCHEMA CHAR(8)
Qualified name of the table where the constraint was introduced.
ORIGIN_TABNAME VARCHAR(18)
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 ]