Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

fire_triggers option

Controls whether triggers are fired in the database.

Allowed values

On, Off

Default

On

Scope
  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
Remarks

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.