Hello Group<

I need to open up a table and replace the current Primary Key value With a totally different Primary Key. The data will be transported to a different table in a different Database that has a different PK system.

I will suppy the next unique Primay Key from a FoxPro 6.0 program. The program will then assign the new PK to the first row and then increment the value from FoxPro and create a new PK for the next row.


How do I do this In Sql Server 7.0
Thanks
Jim