News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV forum how can i reset primar...

Microsoft Dynamics NAV forum

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

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

TeddyH 12,861 Moderator 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 69,657 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... 290,532 Super User 2024 Season 2

#2

Martin Dráb 228,501 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans