想要查看每个表都有那些触发器,可以使用如下语句查询:
select t.name as [trigger_name],u.name as [table_name]
from sysobjects t inner join sysobjects u
on t.parent_obj = u.id and t.xtype ='tr'
想要查看每个表都有那些触发器,可以使用如下语句查询:
select t.name as [trigger_name],u.name as [table_name]
from sysobjects t inner join sysobjects u
on t.parent_obj = u.id and t.xtype ='tr'