Subject Re: [firebird-support] Recreate indexes
Author Milan Babuskov
Thomas Steinmaurer wrote:
>> But If I need to recreate PK what I have to do?
> You have to drop the constraint and re-create it afterwards.

Make sure you first drop all the FK as they depend on PK's. It would go
something like this:

- drop FK constraints
- drop PK and unique constraints
- drop regular indexes
- create regular indexes
- create PK and unique constraints
- create FK constraints

Milan Babuskov