OWNER 

VARCHAR2(30) 

NOT NULL 

Owner of the constraint definition 

CONSTRAINT_NAME 

VARCHAR2(30) 

NOT NULL 

Name of the constraint definition 

CONSTRAINT_TYPE 

VARCHAR2(1) 

Type of constraint definition:

• C (check constraint on a table)

• P (primary key)

• U (unique key)

• R (referential integrity)

• V (with check option, on a view)

• O (with read only, on a view)

TABLE_NAME 

VARCHAR2(30) 

NOT NULL 

Name of the table with constraint definition 

SEARCH_CONDITION 

LONG 

Text of search condition for a check constraint 

R_OWNER 

VARCHAR2(30) 

Owner of table referred to in a referential constraint 

R_CONSTRAINT_NAME 

VARCHAR2(30) 

Name of the unique constraint definition for referenced table 

DELETE_RULE 

VARCHAR2(9) 

Delete rule for a referential constraint: CASCADE or NO ACTION 

STATUS 

VARCHAR2(8) 

Enforcement status of constraint: ENABLED or DISABLED 

DEFERRABLE 

VARCHAR2(14) 

Whether the constraint is deferrable 

DEFERRED 

VARCHAR2(9) 

Whether the constraint was initially deferred 

VALIDATED 

VARCHAR2(13) 

Whether all data obeys the constraint: VALIDATED or NOT VALIDATED 

GENERATED 

VARCHAR2(14) 

Whether the name of the constraint is user or system generated 

BAD 

VARCHAR2(3) 

A YES value indicates that this constraint specifies a century in an ambiguous manner. To avoid errors resulting from this ambiguity, rewrite the constraint using the TO_DATE function with a four-digit year.

See Also: the TO_DATE function in Oracle8i SQL Reference and Oracle8i Application Developer's Guide - Fundamentals. 

RELY 

VARCHAR2(4) 

Whether an enabled constraint is enforced or unenforced.

See Also: the constraint_clause in Oracle8i SQL Reference. 

LAST_CHANGE 

DATE 

When the constraint was last enabled or disabled