Dropping Triggers
From InterBase
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.
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.