Saturday, February 6, 2010

How to reset identity increment

My friend asked me how to reset the identity increment for a specific table so the solution as following:

USE TestDb
GO

DBCC CHECKIDENT ('Employees',RESEED,0)

No comments: