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.