How Can We Help?

Reseed Table Primary Column

Created On
bytechnologyjunction
You are here:
← All Topics

DBCC CHECKIDENT (‘TableName’, RESEED, 0);
GO

Note: 0 is the number to which you want to reset. It could be any number. For example if you have 200 records but you want to keep only 10 records and delete the rest, then you may reset the seed to 10 so that the next insert will be for record id 11.

Table of Contents