Using DROP and REVOKE

---

The following points apply to triggers when using DROP and REVOKE with triggers:

• A trigger can be dropped by using the DROP TRIGGER statement.
• Only the creator of the trigger can drop it using the DROP TRIGGER statement.
• When a trigger is dropped, the comments created on it are also dropped.
• Dropping an object referenced from an SQL statement in a trigger action will cause the trigger to be dropped.
• If the required privileges held on a database object are revoked from the creator of a trigger whose trigger action contains an SQL statement referencing the object, the trigger will be dropped.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se