Oracle Designer Model, Release 6i
Deletion rules


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

Reference PropertyDeletion Rule
COLUMN_REFERENCE Block attempt to delete COLUMN
ENTITY_REFERENCE Cascade delete, if ENTITY deleted
TABLE_REFERENCE Cascade delete, if RELATION_DEFINITION deleted (Owning foreign key)

Impact on child element types if TABLE_ENTITY is deleted

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