A.4 ALL_CONSTRAINTS

ALL_CONSTRAINTS data dictionary for Oracle Database Gateway for DRDA.

The ALL_CONSTRAINTS view contains constraint definitions on accessible tables.

Column name	Description
OWNER	Owner of the constraint definition
CONSTRAINT_NAME	Name of the constraint definition
CONSTRAINT_TYPE	Type of the constraint definition
TABLE_NAME	Name of the table with constraint definition
SEARCH_CONDITION	Text of the search condition for table check
R_OWNER	Owner of the table used in referential constraint
R_CONSTRAINT_NAME	Name of the unique constraint definition for referenced table
DELETE_RULE	Delete rule for a referential constraint
STATUS	Status of a constraint
DEFERRABLE	Whether the constraint is deferrable
DEFERRED	Whether the constraint was initially deferred
VALIDATED	Whether all data obeys the constraint
GENERATED	Whether the name of the constraint is user or system generated
BAD	Constraint specifies a century in an ambiguous manner
RELY	Whether an enabled constraint is enforced or unenforced
LAST_CHANGE	When the constraint was last enabled
INDEX_OWNER	N/A
INDEX_NAME	N/A