Steps to Reset List Item ID in SharePoint 2013/2016/Online

Here we will discuss how we can reset list item id in a SharePoint 2013/2016/Online list. We will be able to know, how to reset id number in SharePoint list.

Every SharePoint list item will have one ID associated with it. If you have 5 items and you delete all 5 items from the SharePoint list then next time if you will try to add one item to the list then the id will starts from 6 not with 1. There is no out of box way you can reset the id apart from resetting the value in the content database.

First Approach: Reset list item id SharePoint 2013

One approach you can do is, you can Save the List as a template and can use the same template to create a new list in SharePoint 2013/2016/Online. You can follow this article to check.

Second Approach: SharePoint 2013 reset List Item ID (Update in Database)

The other way is you can modify in the SharePoint database, and this is not a recommended approach. Remember if you are using SharePoint Online, then you can not modify any database, so this approach will work only in SharePoint 2013/2016.

Before opening your database for modification, make sure you have the list GUID.

AllListsAux table in the content database maintains information about Item count and Id details for all lists.

Then open the database and run the below command:

SELECT * FROM [ContentDBName].[dbo].[AllListsAux] where ListID=’GUID of the List’

Example:
SELECT * FROM [WSS_Content].[dbo].[AllListsAux] where ListID=’B13CC473-6187-4478-A0DD-853E83AA6F9D’



It will display like below:

reset list item id sharepoint 2013

reset list item id sharepoint 2013

Now if you will add an item to the list, the next list item ID will be generated like below:

sharepoint 2013 reset list item id

sharepoint 2013 reset list item id

Then Run the below command to reset the value:

UPDATE [Content DB].dbo.AllListsAux set NextAvailableId=1 where ListID=’GUID of the List’

Example:
UPDATE [WSS_Content].dbo.AllListsAux set NextAvailableId=1 where ListID=’B13CC473-6187-4478-A0DD-853E83AA6F9D’

Now if you will add an item to the list, then the item will be reset (Item ID will start from 1) like below:

how to reset id number in sharepoint list

how to reset id number in SharePoint list

But Microsoft strictly does not recommend to change anything in the content database. Take special care while doing this kind of modifications.

Steps to Reset List Item ID in SharePoint 2013/2016/Online

You may like following SharePoint list and document library tutorials:

Hope this article will be helpful to reset list item id SharePoint 2013/2016 or SharePoint Online.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

Bhawana Rathore

Hello Everyone!! I am Bhawana a SharePoint MVP and having about 8+ years of SharePoint experience as well as in .Net technologies . I have worked in all the versions of SharePoint from wss to Office 365. I have good exposure in Customization and Migration using Nintex, Metalogix tools . Now exploring more in SharePoint 2016 :) Hope here I can contribute and share my knowledge to the fullest. As I believe "There is no wealth like knowledge, and no poverty like ignorance"

>