Creating Triggers

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.

Topics

• CREATE TRIGGER Syntax
• InterBase Procedure and Trigger Language
• The Trigger Header
• The Trigger Body

Advance To:

• CREATE TRIGGER Syntax