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
André Arnaud de Cal... 291,419 Super User 2024 Season 2
Martin Dráb 230,492 Most Valuable Professional
nmaenpaa 101,156