Deletes a trigger definition from the physical database and, if
    the database was attached with PATHNAME, from the repository.

1  –  Environment

    You can use the DROP TRIGGER statement:

    o  In interactive SQL

    o  Embedded in host language programs to be precompiled

    o  As part of a procedure in an SQL module

    o  In dynamic SQL as a statement to be dynamically executed

2  –  Format

  DROP TRIGGER ---> <trigger-name> --+---------------+->
                                     +--> IF EXISTS -+

3  –  Arguments

3.1  –  IF_EXISTS

    Prevents SQL command language from displaying error messages if
    the referenced object does not exist in the database.

3.2  –  trigger-name

    Specifies the name of the trigger to be deleted.

4  –  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>