Post reply

Question about the Identity property of a column

  • March 25, 2009 at 2:42 pm

    #966300

    You could ALTER the table ADD a new column and SET IDENTITY, I don't think you can convert your current column to IDENTITY.

    Kind regards,
    Gift Peddie

  • March 25, 2009 at 2:44 pm

    #966301

    You could add an identity column, set identity insert on, and update to get the same value of your "Current ID" Column, then drop your column. You would then have a new Identity column, with the same values.

    Cheers,

    J-F

  • March 25, 2009 at 2:45 pm

    #966303

    Damn, Gift beat me to it, 😀

    Cheers,

    J-F

  • March 25, 2009 at 3:05 pm

    #966318

    Cool. Thanks. 🙂

    Guess I'm starting to understand this BOL thingie.

    I added the column and dropped the inserted column and it worked just fine. Got the same identity values to match my imported column values. Thanks again.

    -- Kit

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply