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
http://www.guacosoft.com