Application Development Guide

Using Triggers in an Active DBMS

  • Why Use Triggers?
  • Benefits of Triggers
  • Overview of a Trigger
  • Trigger Event
  • Set of Affected Rows
  • Trigger Granularity
  • Trigger Activation Time
  • Transition Variables
  • Transition Tables
  • Triggered Action
  • Triggered Action Condition
  • Triggered SQL Statements
  • Functions Within SQL Triggered Statement
  • Trigger Cascading
  • Interactions with Referential Constraints
  • Ordering of Multiple Triggers
  • Synergy Between Triggers, Constraints, UDTs, UDFs, and LOBs
  • Extracting Information
  • Preventing Operations on Tables
  • Defining Business Rules
  • Defining Actions

    • [ Top of Page | Previous Page | Next Page ]