Skip to main content

Reseeds a table identity value in a SQL Server database table; after deleting all table rows (when truncate isn't an option).

USE <database_name>;
GO

-- Reseed table 'dbo.table_name' identity value to '1':
DBCC CHECKIDENT ('dbo.table_name', RESEED, 1);
GO