Friday 10 February 2017

Check all tables name that contain with trigger :

Select 
[tgr].[name] as [trigger name], 
[tbl].[name] as [table name]
from sysobjects tgr 
join sysobjects tbl
on tgr.parent_obj = tbl.id
WHERE tgr.xtype = 'TR'
Check Below the output will come like :
First column is for trigger name and second column contains table name that having trigger.

No comments:

Post a Comment