Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010

    Unanswered: Turn On Identity seed by sql command

    Hi Experts,

    This time my problem is with identity seed, I just like to turn identity on by sql command. Actually i just had imported data from ms-access where there was autonumber field. When I imported the table in sql server there is no such identity seed and technically its right. But i just like to place identity after that tell how i will achieve this as I have more than 100 tables and like to right a single query script for of my clients.

    Is there any solution.

    Thanks & best Regards

    Jay Khatri

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    You can only set the identity property when the table is created. I don't know of any way to add it as an afterthought.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts