Wednesday 5 September 2012

T-SQL triggers on a table

 
Finding what triggers on a table using t-sql can be performed in T-SQL using the following Query


select t.*

from sysobjects s

inner join sys.triggers t on t.parent_id=s.id

where s.name = '<>'

No comments:

Post a Comment