DROP TRIGGER

From InterBase
Jump to: navigation, search

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.

Example: The following isql statement drops a trigger:

DROP TRIGGER POST_NEW_ORDER;

See Also

Advance To: