Search Here

MyLot Discussion

Wednesday, March 10, 2010

Reset Identity Column in SQL SERVER

The original source from http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx

The following line resets the Identity value for the Customer table to 0 so that the next record added starts at 1.

DBCC CHECKIDENT('Customer', RESEED, 0)

0 Comments: