14
Tables with AutoIncrement primary keys get sometimes overflooded.

Take for example some Log table or a table the receives data via interface for processing.
At some point old/all entries are deleted/archived.

It is desired to reset the last used value of the primary key to 0 to avoid overflow.
It can be done on SQL server, but not directly from AL:
https://mohana-dynamicsnav.blogspot.com/2014/03/reset-autoincrement-field-in-nav.html?spref=fb

Please provide a new function that would check if the table is empty or does not have values in primary key that are equal or bigger than the new reseed value, and would reseed the AutomIncrement value:

Rec.Reseed([NewReseedValue: ])
Category: Development
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team