--查询所有表的触发器

select a.name 数据表名,sysobjects.name as 触发器名,sysobjects.crdate as 创建时间 from sysobjects 

left join (select *from sysobjects where xtype='U')as a on sysobjects.parent_obj=a.id

where sysobjects.xtype='TR'

--查询某张表的触发器

select   *   from   sysobjects   where   xtype='TR'   and   parent_obj=object_id('icstockbill')

--查询所有表的触发器

select triggers.name as [触发器],tables.name as [表名],triggers.is_disabled as [是否禁用],

triggers.is_instead_of_trigger AS [触发器类型],

case when triggers.is_instead_of_trigger = 1 then 'INSTEAD OF'

when triggers.is_instead_of_trigger = 0 then 'AFTER'

else null

end as [触发器类型描述]

from sys.triggers triggers

inner join sys.tables tables on triggers.parent_id = tables.object_id

where triggers.type ='TR' and tables.name='icstockbill'

order by triggers.create_date

大神  求指点 我打开序时簿过滤界面 点下过滤界面的确定按钮后我想获得 我过滤条件的 SQL执行语句 ，用于快速提取数据。谢谢【emoji】