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;
Code language: SQL (Structured Query Language) (sql)

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;
Code language: SQL (Structured Query Language) (sql)
Was this tutorial helpful ?