SQL SERVER 查看所有触发器

https://www.cnblogs.com/guorongtao/p/13329618.html

 

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