MSSQL Trigger 트리거 조회하기

 

 

현재 사용중인 트리거(trigger) 조회하기.

 

select T.name as TriggerName, o.name as TableName
from sys.sysobjects as t
inner join sys.sysobjects as o
on t.parent_obj = o.id
where t.xtype = 'TR'
order by o.name asc