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
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.
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,
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.