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