Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Restart List Item with ID 1

Asked By: Rachelle Mckinney Date: Dec 02, 2009 Category: Sharepoint Views: 405

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, 2009

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

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

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

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

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, 2009

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

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

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, 2009

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.