Hi Mark,
I don't want to delete the column, just the constraint. So I can add a new PK.
Since there are several FKs referencing to that PK, I have to delete the FKs
first. That is the main problem. I'm just looking for a method to delete all
constraints. After that I can cleanly add new ones.
On 22-10-2015 11:20, Köditz, Martin martin.koed...@it-syn.de
[firebird-support] wrote:
> is it possible to restore a database without constraints? Or is there
> another way to do this? I just want do delete each primary key in the db.
Could you explain exactly what you are trying to achieve? For
Hi Rik,
thank you for the info. This helps a lot. The reason why I want to delete the
constraints are wrong namings.
The process is following:
1. Delete foreign keys
2. Delete primary keys
3. Create new keys
I think I can do that via execute blocks as you have shown.
Regards
Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote:
> is it possible to restore a database without constraints? Or is there
> another way to do this? I just want do delete each primary key in the db.
Is this on a healthy DB? I'm not sure if -I disables the constraints in
that case.
I've done that. But the keys still exist and I'm not able to delete them while
there are many dependencies. Maybe the only chance is to delete the foreign
keys first and then the primary keys. Or is there a more graceful way?
Regards
Martin
You just need to use the -i switch with gbak when restoring the database. We
use this when we have a database that has become corrupted and we are then
fixing it with gfix and when it comes to restoring it, it fails due to some
issue with either missing or duplicated data
Cheers,
Neil Pickles
