DROP TRIGGER
This statement removes a trigger from the current database.
Syntax
DROP TRIGGER trigger-name
Examples
The following example drops the trigger named InsTrig.
DROP TRIGGER InsTrig
See Also
CREATE TRIGGER