SQL$HELP72.HLB

    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

  (B)0[m[1;4mDROP[m[1m [1;4mTRIGGER[m[1m qqq> <trigger-name> qqwqqqqqqqqqqqqqqqwq>[m
  [1m               [m                    [1mmqq> [1;4mIF[m[1m [1;4mEXISTS[m[1m qj[m

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>