News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... how can i reset primar...

Small and medium business | Business Central, N...

Suggested answer

how can i reset primary key auto increment after deleting a row in a table

(0) Share

Report

Report

Posted on by Dynamics 365 Community

52

how can i reset primary key auto increment after deleting a row in a table

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

RE: 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.
Suggested answer

YUN ZHU 74,141 Super User 2024 Season 2 on at

Like (0)

Report

RE: how can i reset primary key auto increment after deleting a row in a table

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2

Martin Dráb 230,492 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans