Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Restart List Item with ID 1

  Asked By: Rachelle    Date: Dec 02    Category: Sharepoint    Views: 9434

I was doing some testing on a list by adding some items on a list and
then deleting them. After the testing, I started adding items once again on
the list. But everytime, the Id is incremented. But I want to restart the
Id from 1. I don't want to delete the list and recreate a new one. Is there
a way out?



6 Answers Found

Answer #1    Answered By: Richard Davis     Answered On: Dec 02

How about saving the list  as a template, then create a new list based on the

Answer #2    Answered By: Mason Davis     Answered On: Dec 02

I can't do that....................

Answer #3    Answered By: Savannah Pena     Answered On: Dec 02

No site collection-level permissions?

Sooner or later your client is going to have to grant you more access to get
this job done.

Answer #4    Answered By: Upendra Bordoloi     Answered On: Dec 02

There is no way that I know of to restart  the automatically generated IDs in
list  to 1 other than deleting  the list and recreating it.

Answer #5    Answered By: Ali Javed     Answered On: Dec 02

The ID increment is actually a field in a table the database, I can't remember
the field name.

Answer #6    Answered By: Karrie Wooten     Answered On: Dec 02

Just make sure you tell it not to bring the content along when you save the
list as a template.

Also, be aware that deleting/recreating the list  can mess up any workflows
associated with it (which can be fixed by replacing the old GUID with the
new one inside the xoml file).

Didn't find what you were looking for? Find more on Restart List Item with ID 1 Or get search suggestion and latest updates.