Oct
20
2012

How To Reset Auto-Increment in MS SQL Server

After deleting all the entries in the table. The increment will not reset by it self.

To reset the auto-Increment to 1, use the SQL Query below:

DBCC CHECKIDENT ([Table Name], RESEED, 1)

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Calendar

<<  January 2021  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar