查询SQL SERVER数据库表的触发器清单

SELECT
t.name AS 触发器名称,
OBJECT_NAME(t.parent_id) AS 所属表名,
SCHEMA_NAME(o.schema_id) AS 架构名称,
t.create_date AS 创建日期,
t.modify_date AS 修改日期,
t.is_disabled AS 是否禁用,
t.is_instead_of_trigger AS 是否是INSTEAD_OF触发器
FROM
sys.triggers t
INNER JOIN
sys.objects o ON t.object_id = o.object_id
WHERE
t.parent_id > 0 -- 排除DDL触发器
ORDER BY
所属表名, 触发器名称;