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

<<  July 2020  >>
MoTuWeThFrSaSu
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

View posts in large calendar