Alter Trigger

Usage:

ALTER TRIGGER ON name INSTEAD OF INSERT|UPDATE|DELETE (AS FOR EACH ROW block) | (ENABLED|DISABLED)

Syntax Rules:

  • The target, name, must be an updatable view.

  • Triggers are not yet true schema objects. They are scoped only to their view and have no name.

  • An Update Procedures (Triggers) must already exist for the given trigger event.

results matching ""

    No results matching ""