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;