Reset List Item ID in sharepoint Using SQL

Sharepoint list dosent have an option to reset the ID which is created internally when an item is added on the list. Which is referred to as List Item ID.
OOTB there is no way to reset the List item ID. But Wait its not over … 🙂
If you are ready for it , YES , there is a way to get around this for any list to get it resetted to any starting integer you would like to.
Find the ContentDatabase of the site collection you are tying to modify the List.
Execute the followind SQL query to find the Next item id to be generated.

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

GUID will be of xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx’ without {}
Then RunUPDATE <Content DB>.dbo.AllListsAux set NextAvailableId=1 whereListID='<GUID>’

Here you can see a table called AllListsAux. This list maintans Item count and Id details for all lists.

Please note we have to be very careful while doing any opertation in backend.

Note: Microsoft dosent recommend to update the Sharepoint Content Database directly, Please do not try this on Production Environment

Terms And Conditions Of Use:
All content provided on this  blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site.
The owner of will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.

Leave a Reply

Your email address will not be published. Required fields are marked *