Dropping Triggers

Go Up to Triggers (Data Definition Guide)

During database design and application development, a trigger may no longer be useful. To permanently remove a trigger, use DROP TRIGGER.

The following restrictions apply to dropping triggers:

• Only the creator of a trigger can drop it.
• Triggers currently in use cannot be dropped.

To temporarily remove a trigger, use ALTER TRIGGER and specify INACTIVE in the header.

The DROP TRIGGER syntax is as follows:

DROP TRIGGER name;

The trigger <name> must be the name of an existing trigger. The following example drops the trigger, SET_CUST_NO:

DROP TRIGGER SET_CUST_NO;

You cannot drop a trigger if it is in use by a CHECK constraint (a system-defined trigger). Use ALTER TABLE to remove or modify the CHECK clause that defines the trigger.

Note: Direct metadata operations, such as dropping triggers, increase the metadata version. At most 255 such operations can be performed before you must back up and restore the database.