IBM Books

Administration Guide


OBJCAT.COLCHECKS

Each row represents some column that is referenced by a CHECK constraint defined for a table.

Table 103. OBJCAT.COLCHECKS Catalog View
Column Name Data Type Nullable Description
CONSTNAME VARCHAR(18)
Name of the check constraint. (Unique within a table. May be system generated.)
TABSCHEMA CHAR(8)
Qualified name of table containing referenced column.
TABNAME VARCHAR(18)
COLNAME VARCHAR(18)
Name of column.
ORIGIN_TABSCHEMA CHAR(8)
Qualified name of the table on which the constraint was defined.
ORIGIN_TABNAME VARCHAR(18)


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]