Ways to check whether a trigger exists in SQL Server
Posted by Viral Sarvaiya on December 13, 2011
How to find there are trigger is exists in database or not?
there are 2 ways to find the list of the trigger in database
select * from dbo.sysobjects where OBJECTPROPERTY(id, 'IsTrigger') = 1
select * from sys.triggers
and if you want to find trigger from particular table,
exec sp_helptrigger 'TableName'
select * from sys.triggers where name = 'TableName'