Subject | Temporary disable FK constraint |
---|---|
Author | Scott Morgan |
Post date | 2015-11-06T15:01:48Z |
I have a feeling that the answer is 'no', but...
In a FB2.5 system is there a way to temporarily disable foreign key
constraints? i.e. something like 'ALTER INDEX ... INACTIVE'
Got a big lump of clean data I want to drop into a table.
Alternatively, how safe is dropping/recreating the FKs on the fly?
Scott
In a FB2.5 system is there a way to temporarily disable foreign key
constraints? i.e. something like 'ALTER INDEX ... INACTIVE'
Got a big lump of clean data I want to drop into a table.
Alternatively, how safe is dropping/recreating the FKs on the fly?
Scott