Please enable JavaScript.
Coggle requires JavaScript to display documents.
Active Database (Each trigger is executed in a Trigger Execution Context…
Active Database
Each trigger is executed in a Trigger Execution Context (TEC) to organize recursive trigger activations
If a trigger activates another, it is suspended, the "outer" TEC is saved, an "inner" one is built and its trigger executed
At the end of a trigger, the TEC is restored and the execution is resumed
-
-
SQL:1999 Triggers
Definition syntax
- create trigger name-of-trigger
-
-
-
-
-
-
Through triggers it implements the ECA Paradigm - Execution, Condition, Action