locked
Reset ID back to zero on a list RRS feed

  • Question

  • I have a list i have just set up and made lots of test entries whilst setting up.

     

    I now want to make the list live. Is there a way to reset the ID back to zero?

    Tuesday, February 8, 2011 11:11 AM

Answers

  • ID is a auto increment column. I think we can not reset this one.

    Instead you can do like this:

    1) Create the list template based on existing list.

    2) And create new list using list template which we have created in step 1

    3) Now you have same copy of list here, now you can use it for live.

    Hope you can proceed.


    Thanks & Regards, Neerubee
    • Proposed as answer by Tom Molskow Tuesday, February 8, 2011 10:00 PM
    • Marked as answer by Leoyi Sun Wednesday, February 16, 2011 9:31 AM
    Tuesday, February 8, 2011 11:26 AM
  • Hey Direbus,

    Neerubee is correct in his approach, I would add just one caveat, be sure when creating the list template that you don't check the "Include Content" box or you will have all the items you created again and be back to square one.

    Thanks!

    Tom


    Tom Molskow - SharePoint Architect - MCC 2011 Award - Linked-In - SharePoint Gypsy
    • Marked as answer by Leoyi Sun Wednesday, February 16, 2011 9:31 AM
    Tuesday, February 8, 2011 10:00 PM

All replies

  • ID is a auto increment column. I think we can not reset this one.

    Instead you can do like this:

    1) Create the list template based on existing list.

    2) And create new list using list template which we have created in step 1

    3) Now you have same copy of list here, now you can use it for live.

    Hope you can proceed.


    Thanks & Regards, Neerubee
    • Proposed as answer by Tom Molskow Tuesday, February 8, 2011 10:00 PM
    • Marked as answer by Leoyi Sun Wednesday, February 16, 2011 9:31 AM
    Tuesday, February 8, 2011 11:26 AM
  • I might sound silly here, but why don't you just delete the items if you don't want them.

    If you do want them, then why do you want to set the ID to zero?


    Nitin Sablok - Posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, February 8, 2011 6:38 PM
  • Hey Direbus,

    Neerubee is correct in his approach, I would add just one caveat, be sure when creating the list template that you don't check the "Include Content" box or you will have all the items you created again and be back to square one.

    Thanks!

    Tom


    Tom Molskow - SharePoint Architect - MCC 2011 Award - Linked-In - SharePoint Gypsy
    • Marked as answer by Leoyi Sun Wednesday, February 16, 2011 9:31 AM
    Tuesday, February 8, 2011 10:00 PM