SYS_CHECK_CONSTRAINTS

Information on check constraints.

Column name

Data type

Contents

CONSTRAINT_SCHEMA

CHAR (31)

Name of the schema to which the table
with the check constraint belongs

CONSTRAINT_NAME

CHAR (31)

Name of the check constraint

CHECK_CLAUSE

VARCHAR
(32000)

Search condition

CHECK_TYPE_IND

CHAR (1)

Y	Check constraint is the NOT NULL constraint
N	else

Table 109: SYS_CHECK_CONSTRAINTS view of the SYS_INFO_SCHEMA