常用SQL语句<2>

触发器查询

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 [表名]

常用SQL语句<1>