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

<<  October 2020  >>
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678

View posts in large calendar