Subject Rebuilding primary key index?
Author Kjell Rilbe
Apparently it's not possible to deactivate a primary key index. Seems
reasonable. So, how do I rebuild it?

Drop the PK and add it back again?

Would require I make sure no dups are entered while the PK constraint is
not present. I guess I could add a unique constraint first, then drop
the pk, then add the pk and finally drop the unique constraint. But
seems like I would be building essentially the same index twice, while
once should suffice.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64