SQL SERVER 查看所有触发器
SQL SERVER 查看所有触发器
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 [表名]
创建时间:2020.07.17 更新时间:
博客园 滔Roy https://www.cnblogs.com/guorongtao 希望内容对你有所帮助,谢谢!