CREATE PRIMARY KEY ON LARGE TABLE SQLSEVER code example
Example 1: reseed sql table primary key
DBCC CHECKIDENT ('YourTableName', RESEED, 1)
Example 2: reseed sql table primary key
DBCC CHECKIDENT ('YourTableName', RESEED, 0);
DBCC CHECKIDENT ('YourTableName', RESEED, 1)
DBCC CHECKIDENT ('YourTableName', RESEED, 0);