You must Sign In to post a response.
  • Category: SQL Server

    How can we create alter query for Identity

    In SQL Server (in my case, 2008) how can I add the identity property to an existing table column?
  • #575489
    You cannot set identity property to the existing table column,
    Instead you can add a new identity column and can drop the one
    you do not want.

    Please mark this as Answer, if this helps

    Alwyn Duraisingh.M 
    << Database Administrator >>
    Jesus saves! The rest of us better make backups...

  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.