CREATE TRIGGER Syntax

Go Up to Creating Triggers

The syntax of CREATE TRIGGER is:

CREATE TRIGGER name FOR {table | view}
 [ACTIVE | INACTIVE]
 {BEFORE | AFTER} {DELETE | INSERT | UPDATE}
 [POSITION number]
AS <trigger_body>
<trigger_body> = [<variable_declaration_list>]
 <block>
<variable_declaration_list> = DECLARE VARIABLE variable datatype;
[DECLARE VARIABLE variable datatype; …]
<block> =
BEGIN
<compound_statement>
 [<compound_statement> …]
END
<compound_statement> = <block> | statement;

Arguments of the CREATE TRIGGER statement

Argument	Description
<name>	Name of the trigger. The name must be unique in the database.
<table>	Name of the table or view that causes the trigger to fire when the specified operation occurs on the table or view.
ACTIVE|INACTIVE	Optional. Specifies trigger action at transaction end: ACTIVE: (Default). Trigger takes effect. INACTIVE: Trigger does not take effect.
BEFORE|AFTER	Required. Specifies whether the trigger fires: BEFORE: Before associated operation. AFTER: After associated operation. Associated operations are DELETE, INSERT, or UPDATE.
DELETE|INSERT | UPDATE	Specifies the table operation that causes the trigger to fire.
POSITION <number>	Specifies firing order for triggers before the same action or after the same action. <number> must be an integer between 0 and 32,767, inclusive. Lower-number triggers fire first. Default: 0 = first trigger to fire. Triggers for a table need not be consecutive. Triggers on the same action with the same position number will fire in alphabetic order by name.
DECLARE VARIABLE <var> <    datatype>	Declares local variables used only in the trigger. Each declaration must be preceded by DECLARE VARIABLE and followed by a semicolon (;). <var>: Local variable name, unique in the trigger. <datatype>: The data type of the local variable.
<statement>	Any single statement in InterBase procedure and trigger language. Each statement except BEGIN and END must be followed by a semicolon (;).
<terminator>	Terminator defined by the SET TERM statement which signifies the end of the trigger body; deprecated in InterBase 7.0. [No longer needed]