Monday, June 17, 2013

Reseeding (reseting) the identity of a table is really simple in SQL Server.

Check it out:

DBCC CHECKIDENT (TableName, reseed, 0)

This will reset the identity to 0 and any row inserted from this point on will start with 1. You can set the third parameter to any integer value.

No comments:

Post a Comment