Reset AutoIncrement in SQL Server after Delete

by

I’ve deleted some records from a table in a SQL Server database.

The IDs in the table look like this:

99
100
101
1200
1201…

I want to delete the later records (IDs >1200), then I want to reset the auto increment so the next autogenerated ID will be 102. So my records are sequential, Is there a way to do this in SQL Server?

14 Answers
14

Leave a Comment