【8月11日笔记】查询触发器及所在表语句分享

--查询所有表的触发器

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 'IN