Deletes an existing user-defined trigger from a database. Available in DSQL and
DROP TRIGGER <name>
Name of an existing trigger
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;