SQL Server で、テーブル起因のトリガーの一覧を取得する。

http://bougyuusonnin.seesaa.net/article/142797591.html

select ta.name as table_name, tr.name as trigger_name
from sys.triggers as tr
inner join sys.tables as ta on tr.parent_id = ta.object_id
order by table_name, trigger_name