how can i reset primary key auto increment after deleting a row in a table
how can i reset primary key auto increment after deleting a row in a table
If you are using auto increment, there is no way to reset it. It will keep increasing.
Hi, I don't know the type of your primary key, but if your primary key is using No.Series, you can update Last No. Used in No. Series.
Hope this will help.
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,532 Super User 2024 Season 2
Martin Dráb 228,501 Most Valuable Professional
nmaenpaa 101,148