Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I temporarily disable all constraints in a Table in Firebird 2.1?

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?

like image 830
Fabio Gomes Avatar asked Jun 30 '09 13:06

Fabio Gomes


1 Answers

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.

like image 171
Douglas Tosi Avatar answered Nov 14 '22 23:11

Douglas Tosi