Search

Thursday, January 5, 2012

Reseting Identity


To reset Identity column in SQL use DBCC CHECKIDENT statement which will set the value to a wanted value.

Example:
USE myDatabaseName
GO
DBCC CHECKIDENT (myTableName, RESEED, 50)GO

No comments:

Post a Comment