Create Trigger

Page removed by Steven Hawkins


Usage:

CREATE TRIGGER ON name INSTEAD OF INSERT|UPDATE|DELETE AS FOR EACH ROW block

Syntax Rules:

  • The target, name, must be an updatable view.
  • An INSTEAD OF TRIGGER must not yet exist for the given event.
  • Triggers are not yet true schema objects. They are scoped only to their view and have no name.
    Limitations:
  • There is no corresponding drop operation. See Alter Trigger for enabling/disabling an existing trigger.