数据库中 触发器禁用、启用、查询

数据库中 触发器禁用、启用、查询

--禁用
alter table A1 disable trigger tgr_ A1_insert_update;
go

--启用
alter table A1 enable trigger tgr_ A1_insert_update;
go

--查询目前触发器状态
select tr.name as [触发器],ta.name as [表名],tr.is_disabled as [是否禁用], tr.is_instead_of_trigger AS [触发器类型],
case when tr.is_instead_of_trigger = 1 then 'INSTEAD OF' when tr.is_instead_of_trigger = 0 then 'AFTER' else null end as [触发器类型描述]
from sys.triggers tr
inner join sys.tables ta on tr.parent_id = ta.object_id
where tr.type ='TR'
order by tr.create_date