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

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

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 :)