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
