select o2.name as TableName,o1.name as TriggerName from sysobjects o1 join sysobjects o2 on o1.parent_obj=o2.id where o1.xtype='TR'
select o2.name as TableName,o1.name as TriggerName from sysobjects o1,sysobjects o2 where o1.type='TR' and o1.parent_obj=o2.id
select name from sysobjects where xtype='TR'
select name from sysobjects where type='TR'
select A.name as 触发名, B.name as 触发所在用户表名 from sysobjects A right outer join sysobjects B on A.parent_obj=B.id where A.xtype='TR'将上面的 A.xtype='TR' 换成 A.type='TR' 也可以
from sysobjects o1 join sysobjects o2 on o1.parent_obj=o2.id
where o1.xtype='TR'
from sysobjects o1,sysobjects o2
where o1.type='TR' and o1.parent_obj=o2.id
from sysobjects A right outer join sysobjects B
on A.parent_obj=B.id
where A.xtype='TR'将上面的 A.xtype='TR' 换成 A.type='TR' 也可以