A.4 ALL_CONSTRAINTS
ALL_CONSTRAINTS
data dictionary for Oracle Database Gateway for DRDA.
The ALL_CONSTRAINTS
view contains constraint definitions on accessible tables.
Column name | Description |
---|---|
|
Owner of the constraint definition |
|
Name of the constraint definition |
|
Type of the constraint definition |
|
Name of the table with constraint definition |
|
Text of the search condition for table check |
|
Owner of the table used in referential constraint |
|
Name of the unique constraint definition for referenced table |
|
Delete rule for a referential constraint |
|
Status of a 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 |
|
Constraint specifies a century in an ambiguous manner |
|
Whether an enabled constraint is enforced or unenforced |
|
When the constraint was last enabled |
|
N/A |
|
N/A |
Parent topic: Oracle DB2 Data Dictionary Views