A.21 USER_CONSTRAINTS

USER_CONSTRAINTS data dictionary for Oracle Database Gateway for DRDA.

The USER_CONSTRAINTS view contains constraint definitions on tables owned by the user.

Column name	Description
OWNER	Owner of the constraint definition
CONSTRAINT_NAME	Name associated with the constraint definition
CONSTRAINT_TYPE	Type of the constraint definition
TABLE_NAME	Name associated with the table with constraint definition
SEARCH_CONDITION	Text of the search condition for table check
R_OWNER	Owner of table used in referential constraint
R_CONSTRAINT_NAME	Name of the unique constraint definition for referenced table
DELETE_RULE	Delete rule for 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
LAST_CHANGE	When the constraint was last enabled
INDEX_OWNER	N/A
INDEX_NAME	N/A