Using SQLite

Name

recursive_triggers — Enable recursive trigger calls

Common Usage

PRAGMA recursive_triggers;
PRAGMA recursive_triggers = switch;

Description

The recursive_triggers pragma gets or sets the recursive trigger functionality. If recursive triggers are not enabled, a trigger action will not fire another trigger.

For many years, SQLite did not support recursive triggers. When they were added, the default for this pragma was set to off, in an effort to keep the default settings backwards compatible. The default version of this pragma may change in a future version of SQLite.

See Also

foreign_keys