MS SQL.Trigger - 문법

[ MS SQL.Trigger - 문법 ]

 

 

- 존재시 삭제 : IF EXISTS ( SELECT NAME FROM SYSOBJECTS

                                                WHERE  NAME = ‘ TRG_TBL_LC_DETAIL_INST' AND TYPE = 'TR' )

                               DROP TRIGGER TRG_TBL_LC_DETAIL_INST

                          GO

 - 생성 :   CREATE TIRGGER  trigger_name

                ON TABLE

                [WITH ENCRYPTION]

                {  

                     { FOR { [DELETE], [INSERT] [,] [UPDATE] }

                AS

 

                IF UPDATE (column_name )

                    [ { AND | OR } UPDATE ( column_name ) … ]

 

               DECLARE   @variable_name    type ;

 

                sql_statement [ …. N ]

 

- 수정 :  ALTER TRIGGER

 

- 삭제 :  DROP TRIGGER

 

- 보기 : sp_helptext       tirgger_name