Administration Guide

SYSCAT.COLCHECKS

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

Table 69. SYSCAT.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 VARCHAR(128)
Qualified name of table containing referenced column.
TABNAME VARCHAR(128)
COLNAME VARCHAR(128)
Name of column.
USAGE CHAR(1)

R = Column is referenced in the check constraint.
S = Column is a source column in the system generated column check constraint that supports a summary table.
T = Column is a target column in the system generated column check constraint that supports a summary table.

Column Name	Data Type	Description
CONSTNAME	VARCHAR(18)	Name of the check constraint. (Unique within a table. May be system generated.)
TABSCHEMA	VARCHAR(128)	Qualified name of table containing referenced column.
TABNAME	VARCHAR(128)
COLNAME	VARCHAR(128)	Name of column.
USAGE	CHAR(1)	R = Column is referenced in the check constraint. S = Column is a source column in the system generated column check constraint that supports a summary table. T = Column is a target column in the system generated column check constraint that supports a summary table.

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

[ DB2 List of Books | Search the DB2 Books ]