Trigger 트리거 관련 정보 조회.

SELECT (SELECT F.name FROM sysusers F WHERE N.uid=F.uid) as 'TABLE_OWNER'
  ,N.name as 'TABLE_NAME'
  ,(SELECT G.name FROM sysusers G WHERE T.uid=G.uid) as 'TRIGGER_OWNER'
  ,T.TRIGGER_NAME as 'TRIGGER_NAME'
FROM sysobjects N,
(SELECT name as TRIGGER_NAME, parent_obj,crdate,uid FROM sysobjects WHERE xtype='TR' and name like 'TR_%') T
WHERE N.id=T.parent_obj
ORDER BY T.TRIGGER_NAME