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