34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT OBJECT_NAME(parent_obj) AS 表名, name AS 触发器名, crdate 创建时间, refdate 更新时间
FROM sysobjects
WHERE xtype = 'TR'
ORDER BY 更新时间 DESC
SELECT name,
definition --查看定义代码
FROM sys.triggers AS a
JOIN sys.sql_modules AS b
ON a.object_id = b.object_id
WHERE name = 'MyTrigger11'--指定要查看其代码的触发器的名称 省略查询所有
ORDER BY name;
SELECT name 触发器名称,
'AFTER或INSTEAD OF 触发器'=
(CASE is_instead_of_trigger
WHEN 1 THEN 'INSTEAD OF'
ELSE 'AFTER'
END),
'DML或DDL触发器'=
(CASE parent_class
WHEN 1 THEN 'DML'
ELSE 'DDL'
END)
FROM sys.triggers
ORDER BY name;