SQL Reference

SYSCAT.CHECKS

Contains one row for each CHECK constraint.

Table 46. SYSCAT.CHECKS Catalog View
Column Name Data Type Nullable Description
CONSTNAME VARCHAR(18)
Name of the check constraint (unique within a table.)
DEFINER VARCHAR(128)
Authorization ID under which the check constraint was defined.
TABSCHEMA VARCHAR(128)
Qualified name of the table to which this constraint applies.
TABNAME VARCHAR(128)
CREATE_TIME TIMESTAMP
The time at which the constraint was defined. Used in resolving functions that are used in this constraint. No functions will be chosen that were created after the definition of the constraint.
QUALIFIER VARCHAR(128)
Value of the default schema at time of object definition. Used to complete any unqualified references.
TYPE CHAR(1)
Type of check constraint:

A = System generated check constraint for GENERATED ALWAYS column

C = Check constraint

FUNC_PATH VARCHAR(254)
The current SQL path that was used when the constraint was created.
TEXT CLOB(64K)
The text of the CHECK clause.


[ Top of Page | Previous Page | Next Page ]