Oracle Designer Model, Release 6i
Deletion rules
Deletion rules on EVENT_TRIGGER reference properties, i.e. rule if referenced element is deleted
| Reference Property | Deletion Rule |
| TRIGGERING_FUNCTION_REFERENCE | Block attempt to delete FUNCTION |
| TRIGGERED_EVENT_REFERENCE | Cascade delete, if EVENT deleted (Owning foreign key) |
| TRIGGERING_EVENT_REFERENCE | Cascade delete, if EVENT deleted |
| TRIGGERED_FUNCTION_REFERENCE | Cascade delete, if FUNCTION deleted (Owning foreign key) |
Impact on child element types if EVENT_TRIGGER is deleted
| Impact on children | Via child reference property |
| Cascade delete DIAGRAM_ELEMENT_USAGES | DIAGRAM_ELEMENT_USAGE.CIELEMENT_REFERENCE |