How can I temporarily disable all constraints in a Table in Firebird 2.1?
constraints, firebird, firebird2.1, sql
Solution
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.
Problem
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?