Oracle Designer Model, Release 6i
Deletion rules


Deletion rules on ATTRIBUTE_QUALIFIER reference properties, i.e. rule if referenced element is deleted

Reference PropertyDeletion Rule
COLUMN_REFERENCE Cascade delete, if COLUMN deleted
CQA_REFERENCE Cascade delete, if COLUMN_QUALIFIED_ATTRIBUTE deleted (Owning foreign key)

Impact on child element types if ATTRIBUTE_QUALIFIER is deleted

Impact on childrenVia child reference property
Cascade delete DIAGRAM_ELEMENT_USAGES DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE