Primary Key

How do I change the primary key to a different column?

Best Answer

  • AKnight
    AKnight ✭✭✭✭✭
    Answer ✓

    Hi @Jenn123 !

    Not directly, no. The workaround is to:

    1. Make a new column (column A)
    2. Copy/paste the old primary data into the new column, column A
    3. Copy/Paste the new desired data (column B) into the primary column
    4. Delete column B
    5. Rename the Primary column
    6. Rename Column A to whatever it was supposed to be

    Ashley Knight

    Lets Connect!

Answers

  • AKnight
    AKnight ✭✭✭✭✭
    Answer ✓

    Hi @Jenn123 !

    Not directly, no. The workaround is to:

    1. Make a new column (column A)
    2. Copy/paste the old primary data into the new column, column A
    3. Copy/Paste the new desired data (column B) into the primary column
    4. Delete column B
    5. Rename the Primary column
    6. Rename Column A to whatever it was supposed to be

    Ashley Knight

    Lets Connect!