Changing Primary Key

[forwardslash]

Hello

I need to change the primary key in the DB. Is the a way to do it without deleting the data. At this point it would not be a probelm since this is a new project.

Any idea's anyone could give me would be great.

Thanks

Michele

 

[DonQuichote]

In theory: no (primary key values should never change).
In practice: Yes:
You can create an new unique index on a new field and use that as your new primary key. If you have relationships from other tables to the table you modified, you have to modify the referring tables as well.
If all references and relations are finished, you can delete the old ones.

Best regards