Forms of Declaration
Firebird supports two forms of declaration for relation triggers:
-
The legacy syntax
-
The SQL standard-compliant form (recommended)
A relation trigger specifies — among other things — a phase and one or more events.
Firebird supports two forms of declaration for relation triggers:
The legacy syntax
The SQL standard-compliant form (recommended)
A relation trigger specifies — among other things — a phase and one or more events.
Phase concerns the timing of the trigger with regard to the change-of-state event in the row of data:
A BEFORE
trigger is fired before the specified database operation (insert, update or delete) is carried out
An AFTER
trigger is fired after the database operation has been completed