Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > CREATE TRIGGER >

Syntax

Read syntax diagramSkip visual syntax diagram>>-CREATE TRIGGER--+---------------------+--trigger------------->
                   |                (1)  |
                   '-| Owner Name |------'
 
>--+---------------------------------------------------+-------->
   |                        (2)                        |
   +-| Trigger on a Table |----------------------------+
   |  (3)                                              |
   '--------INSTEAD OF--+----------------------------+-'
                        |                       (4)  |
                        '-| Trigger on a View |------'
 
    (3)   .-ENABLED--.
>---------+-DISABLED-+-----------------------------------------><
 
Notes:
  1. See page Owner Name
  2. See page Defining a Trigger Event and Action
  3. Dynamic Server only
  4. See page INSTEAD OF Triggers on Views (IDS)
Element Description Restrictions Syntax
trigger Name that you declare here for a new trigger Must be unique among the names of triggers in the current database Identifier, p. Identifier
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]