|
|
| |
 |
|
Oracle Tips by Burleson |
DBA CONS VIEWS
DBA_CONSTRAINTS
Constraint definitions on all tables
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the table
CONSTRAINT_NAME VARCHAR2 Name associated with constraint definition
CONSTRAINT_TYPE VARCHAR2 Type of constraint definition
TABLE_NAME VARCHAR2 Name associated with table with constraint definition
SEARCH_CONDITION LONG Text of search condition for table check
R_OWNER VARCHAR2 Owner of table used in referential constraint
R_CONSTRAINT_NAME VARCHAR2 Name of unique constraint definition for referenced table
DELETE_RULE VARCHAR2 The delete rule for a referential constraint
STATUS VARCHAR2 Enforcement status of constraint - ENABLED or DISABLED
DEFERRABLE VARCHAR2 Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE
DEFERRED VARCHAR2 Is the constraint deferred by default - DEFERRED or IMMEDIATE
VALIDATED VARCHAR2 Was this constraint system validated? - VALIDATED or NOT VALIDATED
GENERATED VARCHAR2 Was the constraint name system generated? - GENERATED NAME or USER NAME
BAD VARCHAR2 Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.
RELY VARCHAR2 If set, this flag will be used in optimizer
LAST_CHANGE DATE The date when this column was last enabled or disabled
INDEX_OWNER VARCHAR2 The owner of the index used by this constraint
INDEX_NAME VARCHAR2 The index used by this constraint
INVALID VARCHAR2
VIEW_RELATED VARCHAR2
DBA_CONS_COLUMNS
Information about accessible columns in constraint definitions
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the constraint definition
CONSTRAINT_NAME VARCHAR2 Name associated with the constraint definition
TABLE_NAME VARCHAR2 Name associated with table with constraint definition
COLUMN_NAME VARCHAR2 Name associated with column or attribute of object column specified in the constraint definition
POSITION NUMBER Original position of column or attribute in definition
DBA_CONS_OBJ_COLUMNS
List of types an object column or attribute is constrained to in all tables in the database
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the table
TABLE_NAME VARCHAR2 Name of the table containing the object column or attribute
COLUMN_NAME VARCHAR2 Fully qualified name of the object column or attribute
CONS_TYPE_OWNER VARCHAR2 Owner of the type that the column is constrained to
CONS_TYPE_NAME VARCHAR2 Name of the type that the column is constrained to
CONS_TYPE_ONLY VARCHAR2 Indication of whether the column is constrained to ONLY type
|
|
|
