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
semi-automatically.

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
back.

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

Thanks,

Chuck Belanger