工程師的雜記

--查詢目前資料Trigger全部
SELECT SCHEMA_NAME(tb.schema_id) N'結構描述', OBJECT_NAME(t.parent_id) N'資料表', t.name N'觸發程序名稱', parent_class_desc N'觸發程序父類別的描述', 
 t.type_desc N'物件類型的描述',  tEV.type_desc '引發觸發程序的每個事件', is_instead_of_trigger N'是否為 INSTEAD OF 觸發程序'
FROM sys.triggers t INNER JOIN sys.trigger_events tEV ON t.object_id = tEV.object_id 
 INNER JOIN sys.tables tb ON t.parent_id = tb.object_id
GO

--提取Trigger

--查看目前資料庫Trigger的語法
USE [go2elife_bk]
select
so.name as tri_name,
so2.name as table_name,
sc.text as tri_content
from sysobjects so
inner join syscomments sc
on
so.id=sc.id and so.xtype='TR'
inner join sysobjects so2
on
so.parent_obj = so2.id

================================原文出處
http://delphi.ktop.com.tw/board.php?cid=30&fid=66&tid=63405
http://sharedderrick.blogspot.com/2013/08/dml-trigger.html