27,579
社区成员
发帖
与我相关
我的任务
分享
列出所有触发器
select so2.name as [Table] , so1.name [Trigger],
so1.refdate,
case sc.encrypted
when 0 then sc.text
else 'unreadable'
end
as Defination
from syscomments sc inner join sysobjects so1 on sc.id= so1.id
inner join sysobjects so2 on so1.parent_obj = so2.id
where so1.xtype='TR' and so2.xtype='U'