sqlserver查找某个表的触发器triggers

SELECT name AS '触发器名称', OBJECT_NAME(parent_id) AS '关联表', type_desc AS '触发器类型', OBJECT_DEFINITION(object_id) AS '触发器定义'
FROM sys.triggers
WHERE parent_class = 1 AND OBJECT_NAME(parent_id) = 'YourTableName';

如：
SELECT name AS tname, OBJECT_NAME(parent_id) AS ttable, type_desc AS ttype, OBJECT_DEFINITION(object_id) AS tdefine
FROM sys.triggers
WHERE parent_class = 1 AND OBJECT_NAME(parent_id) = 'a_user';