home - keyword index

Table: USER_CONSTRAINTS

Constraint definitions on user's own tables

Column Name Description
BAD Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.
CONSTRAINT_NAME Name associated with constraint definition
CONSTRAINT_TYPE Type of constraint definition
DEFERRABLE Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE
DEFERRED Is the constraint deferred by default - DEFERRED or IMMEDIATE
DELETE_RULE The delete rule for a referential constraint
GENERATED Was the constraint name system generated? - GENERATED NAME or USER NAME
INDEX_NAME The index used by the constraint
INDEX_OWNER The owner of the index used by the constraint
INVALID
LAST_CHANGE The date when this column was last enabled or disabled
OWNER Owner of the table
RELY If set, this flag will be used in optimizer
R_CONSTRAINT_NAME Name of unique constraint definition for referenced table
R_OWNER Owner of table used in referential constraint
SEARCH_CONDITION Text of search condition for table check
STATUS Enforcement status of constraint - ENABLED or DISABLED
TABLE_NAME Name associated with table with constraint definition
VALIDATED Was this constraint system validated? - VALIDATED or NOT VALIDATED
VIEW_RELATED

home - keyword index

Comment on this page: