Subject Is it possible to do this with FK Constraints?
Author Chuck Belanger
During a DB update that I apply to my users' desktop application, I need
to Drop all FK constraints then add them back when all the updates of
the various tables are complete.

I have been issuing explicit DSQL statements to do this, but would like
to go through the RDB$ tables and create the DROP statements

So, when I DROP a constraint does its presence in the system tables
cease to exist? If so, I was thinking of storing the FK constraints into
a table before DROPping them then use that table to ADD the constraints

Would this work? Any issues I should be aware of?


Chuck Belanger