Identity reset

[FireOnMoon]

How to reset a database's identity value to 0, after deleting all rows from a table.

FIRE

[_AK_]

I don't know the exact way but one workaround is there. You change that column identity to no and again reset it to yes, next time it will start from one. :)

Best Regards, Apurva Kaushal

[Colin Angus Mackay]

I refer you to the answer I gave some time ago[^]

---

Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog