Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Static Data Dictionary Views, 15 of 521
ALL_CONSTRAINTS
describes constraint definitions on tables accessible to the current user.
DBA_CONSTRAINTS
describes all constraint definitions in the database.
USER_CONSTRAINTS
describes constraint definitions on tables in the current user's schema.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the constraint definition |
|
|
|
Name of the constraint definition |
|
|
|
Type of constraint definition: |
|
|
|
Name associated with the table (or view) with constraint definition |
|
|
|
Text of search condition for a check constraint |
|
|
|
Owner of table referred to in a referential constraint |
|
|
|
Name of the unique constraint definition for referenced table |
|
|
|
Delete rule for a referential constraint ( |
|
|
|
Enforcement status of constraint ( |
|
|
|
Whether the constraint is deferrable |
|
|
|
Whether the constraint was initially deferred |
|
|
|
Whether all data obeys the constraint ( |
|
|
|
Whether the name of the constraint is user or system generated |
|
|
|
A
See Also: the |
|
|
|
Whether an enabled constraint is enforced or unenforced. See Also: the constraint_clause in Oracle9i SQL Reference |
|
|
|
When the constraint was last enabled or disabled |
INDEX_OWNER |
VARCHAR2(30) |
|
Name of the user owning the index |
INDEX_NAME |
VARCHAR2(30) |
|
Name of the index |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|