Changing Indentity Specification

Posted on 2011-05-06
Last Modified: 2012-05-11
For my primary key in a table, I need to change the Identity Specification to Yes, Identity Increment to 1 and Identity Seed to 1.  I'm trying to type in field but its not accepting it (acting like its locked).  How do I modify these properties?
Question by:gcgcit
    LVL 9

    Expert Comment

    You should first set Identity Specification to YES then other fields get activated after that.
    LVL 33

    Expert Comment

    Is there already data in this table?
    LVL 9

    Accepted Solution

    Sorry I think I have mis read your question, Are you trying to do this for an Existing column then it is not possible

    You can't alter the existing columns for identity.

    You have 2 options,

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

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

    Expert Comment

    ... after step 2 above you can re-name the new column back to it's original name.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now