DROP TRIGGER
From InterBase
Go Up to Statement and Function Reference (Language Reference Guide)
Deletes an existing user-defined trigger from a database. Available in DSQL and isql.
DROP TRIGGER <name>
| Argument | Description |
|---|---|
|
<name> |
Name of an existing trigger |
Description: DROP TRIGGER removes a user-defined trigger definition from the database. System-defined triggers, such as those created for CHECK constraints, cannot be dropped. Use ALTER TABLE to drop the CHECK clause that defines the trigger.
Triggers used by an active transaction cannot be dropped until the transaction is terminated.
A trigger can be dropped by its creator, the SYSDBA user, or any user with operating system root privileges.
Tip:
To inactivate a trigger temporarily, use ALTER TRIGGER and specify INACTIVE in the header.
To inactivate a trigger temporarily, use ALTER TRIGGER and specify INACTIVE in the header.
Example: The following isql statement drops a trigger:
DROP TRIGGER POST_NEW_ORDER;