SQL Reference

SYSCAT.COLCHECKS

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

Table 48. 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 check constraint that supports a generated column.
T = Column is a target column in the system generated check constraint that supports a generated column.

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 check constraint that supports a generated column. T = Column is a target column in the system generated check constraint that supports a generated column.

[ Top of Page | Previous Page | Next Page ]