Name

fk_check_input_values — alter default foreign key checking behavior

Synopsis

DB.DBA. fk_check_input_values ( in mode integer );
 

Description

mode = 1 - on
mode = 0 - off

Enforcing foreign key constraints is enabled by default. This function allows globally disabling it without however disabling all triggers. This may be useful for large data imports or other special circumstances. The return value is the previous state of this setting, 0 for off, 1, for on. The effect of this function is persistent and survives server restart.