SYS_CHECK_USAGE

Information on tables and columns of the check constraint.

Column name

Data type

Contents

CONSTRAINT_SCHEMA

CHAR (31)

Name of the schema to which the check
constraint belongs

CONSTRAINT_NAME

CHAR (31)

Name of the check constraint

TABLE_SCHEMA

CHAR (31)

Name of the schema to which the table or
column used by the check constraint
belongs

TABLE_NAME

CHAR (31)

Name of the table used in the check
constraint or to which the column belongs

COLUMN_NAME

CHAR (31)

Name of the table column used in the
check constraint
Blanks if information on the table

OBJECT_INDICATOR

CHAR (1)

T Row contains information on table

C Row contains information on column

NOT_NULL_COLUMN

CHAR (1)

Y	Check constraint forces NOT NULL constraint on the column
N	else

Table 110: SYS_CHECK_USAGE view of the SYS_INFO_SCHEMA