Example 1 Delete a single trigger definition: RDO> DELETE TRIGGER EMPLOYEE_ID_CASCADE_DELETE. This example shows the deletion of a trigger, EMPLOYEE_ID_ CASCADE_DELETE.