DROP TRIGGER Statement

Removes a trigger from a database.

Syntax

DROP TRIGGER [owner.]trigger_name [, [owner.]trigger_name...]

where

trigger_name

Specifies the trigger(s) to remove.

Remark

You can remove a trigger by dropping it or by dropping the trigger table. When a table is dropped, all triggers associated with it are also dropped.

If a new trigger will replace the previous trigger, use the CREATE TRIGGER statement instead. For details, see the CREATE TRIGGER statement.

When you drop a trigger, information about the trigger is removed from the sysprocedures, sysobjects, and syscomments system tables.

Permission

DROP TRIGGER permission defaults to the trigger table owner and is not transferable. However, the system administrator and database owner can drop any object by explicitly specifying the owner in the DROP TRIGGER statement.

Example

This example drops the employee_insupd trigger.

DROP TRIGGER employee_insupd

See Also