解决方法
DROP TRIGGER：
Removes one or more triggers from the current database…
You can remove a trigger by dropping it or by dropping the trigger table. When a table is dropped,all associated triggers are also dropped. When a trigger is dropped,information about the trigger is removed from the sysobjects and syscomments system tables.
Use DROP TRIGGER and CREATE TRIGGER to rename a trigger. Use ALTER TRIGGER to change the definition of a trigger…
