I want to disable all Foreign key constraints and re-enable them after, is there some way to do that?
I know that SQLServer allows that, but what about Firebird?
AFAICT foreign keys can't be disabled in Firebird up to 2.1.
You'd have to drop and recreate them.
There's a similar thread on Devshed.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With