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