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>