is there a short way to change an existing row's primary key or do I need to delete the row and re-insert it with the new key?
BR
Daniel
Let me know If I may be of further assistance.
Hello dclausen,
Thank you for using our forum!
No, there isn't. The correct and recommended way is exactly your assumption. You will need to re-insert it with the new key, because the primary key is to uniquely identify all records and cannot be modified once created.
Let me know if I may be of further assistance.