DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.COLCHECKS catalog view

Each row represents a column that is referenced by a check constraint or by the definition of a materialized query table. For table hierarchies, each check constraint is recorded only at the level of the hierarchy where the constraint was created.

Table 1. SYSCAT.COLCHECKS Catalog View
Column Name Data Type Nullable Description
CONSTNAME VARCHAR (128)   Name of the check constraint.
TABSCHEMA VARCHAR (128)   Schema name of the table containing the referenced column.
TABNAME VARCHAR (128)   Unqualified name of the table containing the referenced column.
COLNAME VARCHAR (128)   Name of the column.
USAGE CHAR (1)  
  • D = Column is the child in a functional dependency
  • P = Column is the parent in a functional dependency
  • R = Column is referenced in the check constraint
  • S = Column is a source in the system-generated column check constraint that supports a materialized query table
  • T = Column is a target in the system-generated column check constraint that supports a materialized query table