Sql Server获取所有表的触发器
Sql语句:
select t.name 表名,tr.name 触发器名称 from (select * from sysobjects where xtype='U') t inner join (select * from sysobjects where xtype='TR') tr on t.id=tr.parent_obj
结果:

Sql语句:
select t.name 表名,tr.name 触发器名称 from (select * from sysobjects where xtype='U') t inner join (select * from sysobjects where xtype='TR') tr on t.id=tr.parent_obj
结果:
