Creating Triggers

From InterBase
Jump to: navigation, search

Go Up to Triggers (Data Definition Guide)

A trigger is defined with the CREATE TRIGGER statement, which is composed of a header and a body. The trigger header contains:

  • A trigger name, unique within the database.
  • A table name, identifying the table with which to associate the trigger.
  • Statements that determine when the trigger fires.

The trigger body contains:

  • An optional list of local variables and their data types.
  • A block of statements in InterBase procedure and trigger language, bracketed by BEGIN and END. These statements are performed when the trigger fires. A block can itself include other blocks, so that there may be many levels of nesting.


Advance To: