想要查看每个表都有那些触发器，可以使用如下语句查询：
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'