Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to reset count for identity field?
Message
General information
Forum:
ASP.NET
Category:
Databases
Title:
How to reset count for identity field?
Miscellaneous
Thread ID:
00819923
Message ID:
00819923
Views:
61
I'm having trouble figuring out how to reset an identity field's sequential count in a table, after I manually delete one or more records.

As it is, when I delete the last record in a table, the next record I add adopts the next higher number, as though I hadn't deleted it at all.

I tried changing the seed, but that didn't help, so I set it back to 1.

TIA,
Jeff

Read about the greatest fraud in the history of mankind.
See TaxableIncome.net.
Next
Reply
Map
View

Click here to load this message in the networking platform