Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1085
Change row's primary key
posted

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

  • 20255
    Offline posted

    Let me know If I may be of further assistance.

  • 20255
    Offline posted

    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.