How to alter column to identity(1,1)

Viewing 1 post (of 1 total)
  • Author
    Posts
  • December 23, 2011 at 11:45 am #3246
    Ankur
    Member

    You can’t alter the existing columns for identity.

    There are two methods which you can use to Alter Column as Identity-

    1. Create a new table with identity & drop the existing table

    2. Create a new column with identity & drop the existing column

    if your table is not blank then before drop the table you need to first copy data in temp table.

  • Author
    Posts
Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.