Oracle Designer Model, Release 6i
Deletion rules


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

Reference PropertyDeletion Rule
CIELEMENT_REFERENCE Cascade delete, if CIELEMENT deleted (Owning foreign key)
PREFERENCE_SET_REFERENCE Cascade delete, if PREFERENCE_SET deleted

Impact on child element types if PREFERENCE_SET_USAGE is deleted

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