SQL SERVER 查看所有触发器

SQL SERVER 查看所有触发器

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

SELECT      object_name(a.parent_obj) as [表名]     ,a.name as [触发器名称]     ,(case when b.is_disabled=0 then '启用' else '禁用' end) as [状态]     ,b.create_date as [创建日期]     ,b.modify_date as [修改日期]     ,c.text as [触发器语句] FROM sysobjects a     INNER JOIN sys.triggers b         ON b.object_id=a.id     INNER JOIN syscomments c         ON c.id=a.id WHERE a.xtype='tr' ORDER BY [表名]

　　

 

创建时间：2020.07.17　　更新时间：