| Summary information | |
|---|---|
| Default value | 1 (on) | 
| Valid values | 0 (off), 1 (on) | 
| Status | Static | 
| Display level | Intermediate | 
| Required role | System Administrator | 
allow nested triggers controls the use of nested triggers. When the value is set to 1, data modifications made by triggers can fire other triggers. Set allow nested triggers to 0 to disable nested triggers. A set option, self_recursion, controls whether the modifications made by a trigger can cause that trigger to fire again.