테이블에 걸려있는 트리거 확인

 

 

SELECT       'sp_helptext ' + T.name
FROM          sys.sysobjects AS T
INNER JOIN  sys.sysobjects AS O
            ON  T.parent_obj = O.id
WHERE        T.xtype ='TR'
                  AND O.name like '테이블명'