IBM Books

Administration Guide


SYSCAT.CHECKS

Contains one row for each CHECK constraint.

Table 61. SYSCAT.CHECKS Catalog View
Column Name Data Type Nullable Description
CONSTNAME VARCHAR(18)
Name of the check constraint (unique within a table.)
DEFINER CHAR(8)
Authorization ID under which the check constraint was defined.
TABSCHEMA CHAR(8)
Qualified name of the table to which this constraint applies.
TABNAME VARCHAR(18)
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.
FUNC_PATH VARCHAR(254)
The current SQL path that was used when the constraint was created.
TEXT CLOB(32K)
The text of the CHECK clause.


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

[ DB2 List of Books | Search the DB2 Books ]