Post reply

Identity

  • January 25, 2005 at 10:55 am

    #87377

    How to reset the Identity column??

    I am using identity column and I want to reset to 1 back how to do that?

    Nita

     

  • January 25, 2005 at 11:13 am

    #539019

    If you do not have dependacies you can :

    1. extract data

    2. trancate table

    3. load data back

    Leonid

  • January 25, 2005 at 11:31 am

    #539023

    As long as changing the identity isn't going to affect dependencies you can use dbcc checkident(tablename, reseed, 1)...

    This will reseed your identity value back to 1 and the next value incremented to will be 2

    Thanks,

    Anthony

  • January 25, 2005 at 12:04 pm

    #539028

    Thanks

    Nita

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

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