The DROP TRIGGER statement drops (or deletes) a trigger defined on a table from the system catalog. You must be the owner of a table or have DBA authority to delete a trigger from a table.
Examples: Dropping triggers
DROP TRIGGER update_acct_balance; -- Using schema and trigger name DROP TRIGGER savings_accounts.update_acct_balance; -- Using catalog, schema, and trigger name DROP TRIGGER accounts.savings_accounts.update_acct_balance;
Example: Dropping and re-creating a trigger
DROP TRIGGER TRIGGER_BI; COMMIT WORK;
"CREATE TRIGGER TRIGGER_BI ON TRIGGER_TEST BEFORE INSERT REFERENCING NEW BI AS NEW_BI BEGIN EXEC SQL PREPARE BI INSERT INTO TRIGGER_OUTPUT VALUES( 'BI_NEW', TRIG_NAME(0), TRIG_SCHEMA(0)); EXEC SQL EXECUTE BI; SET NEW_BI = 'TRIGGER_BI_NEW'; END"; COMMIT WORK;
INSERT INTO TRIGGER_TEST(XX) VALUES ('XX'); COMMIT WORK;
SELECT * FROM TRIGGER_TEST; SELECT * FROM TRIGGER_OUTPUT; COMMIT WORK;