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