|
Controls whether triggers are fired in the database.
On, Off
On
| PUBLIC role | For current user | For other users | |
|---|---|---|---|
| Allowed to set permanently? | Yes, with SET ANY SYSTEM OPTION | Yes, with SET ANY SYSTEM OPTION | Yes, with SET ANY SYSTEM OPTION |
| Allowed to set temporarily? | Yes, with SET ANY SYSTEM OPTION | Yes (current connection only), with SET ANY SYSTEM OPTION | No |
When set to On, triggers are fired. When set to Off, no triggers are fired, including referential integrity triggers (such as cascading updates and deletes). The -gf option overrides this option, which turns off all trigger firing regardless of the fire_triggers setting.
This option is relevant when replicating data from Adaptive Server Enterprise to SQL Anywhere because all actions from Adaptive Server Enterprise transaction logs are replicated to SQL Anywhere, including actions performed by triggers.