View Existing Triggers – Drop One or More Triggers in Sql Server 2005
To view the existing triggers in the database
SELECT * FROM sys.triggers OR SELECT * FROM sysobjects WHERE xtype='TR'
To view the existing triggers in a specified table
sp_helptrigger tablename
To drop a trigger
DROP TRIGGER triggername
To drop more triggers at a time
DROP TRIGGER [trigger1],[trigger2],[trigger3]...[triggern]
Popularity: 3% [?]