0

I have a column with Identity property with 10 records now I had truncated the table but the identity number is stil incrementing from 10 . I need to reset the identity number from 1 again. How to perform this in SQL SERVER 2008

Logeshwaran Veluchamy
  • 141
  • 1
  • 3
  • 12
  • Is identity set to start from 10? However, if there is no data at the moment, why don't you drop and re-create the table? – huMpty duMpty Apr 15 '14 at 10:22

2 Answers2

0

Use DBCC CHECKIDENT with RESEED.

http://technet.microsoft.com/en-us/library/ms176057.aspx

dean
  • 9,960
  • 2
  • 25
  • 26
0

Use this syntax to reset identity column:

DBCC CHECKIDENT(<table_name>, RESEED, value)
Pradeep Kesharwani
  • 1,480
  • 1
  • 12
  • 21