Summary: in this tutorial, you will learn how to use the Db2 DROP TRIGGER statement to remove a trigger from the database.
The DROP TRIGGER statement allows you to delete a trigger from the database. The syntax of the DROP TRIGGER is the following:
DROP TRIGGER trigger_name;
In this syntax, you specify the name of the trigger which you want to delete after the DROP TRIGGER keywords.
Db2 does not allow you to delete multiple triggers using a single DROP TRIGGER statement. Therefore, to delete multiple triggers, you have to execute the DROP TRIGGER multiple times.
If you delete a trigger that does not exist, you will get an error. Unfortunately, Db2 does not support the IF EXISTS option that conditionally deletes a trigger if it exists.
The following example uses the DROP TRIGGER statement to delete the update_headcount trigger created in the CREATE TRIGGER tutorial:
DROP TRIGGER update_headcount;