SQL$HELP_OLD72.HLB  —  DROP  TRIGGER  Examples
    Example 1: Deleting the EMPLOYEE_ID_CASCADE_DELETE trigger

    SQL> ATTACH 'FILENAME personnel';
    SQL> SHOW TRIGGERS
    User triggers in database with filename PERSONNEL
         COLLEGE_CODE_CASCADE_UPDATE
         EMPLOYEE_ID_CASCADE_DELETE
         STATUS_CODE_CASCADE_UPDATE
    SQL> DROP TRIGGER EMPLOYEE_ID_CASCADE_DELETE;
    SQL> SHOW TRIGGERS
    User trigggers in database with filename PERSONNEL
         COLLEGE_CODE_CASCADE_UPDATE
         STATUS_CODE_CASCADE_UPDATE
    SQL>
Close Help