Loading

Using DBCC CHECKIDENT Command to Reseed a Table After Delete in SQL Server

Lajapathy Arun

Comments

Join the conversation! Your thoughts help the community grow.

We are going to see how to use DBCC CHECKIDENT command to Reseed a Table After Delete in SQL Server.

Syntax:

DBCC CHECKIDENT('AnyTableName', RESEED, @max_seed)

For further explanation and example refer below link:

http://sqlserverplanet.com/tsql/using-dbcc-checkident-to-reseed-a-table-after-delete

Thanks :)