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.


Syntax:

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


For further explanation and example refer below link:


Thanks :)
Ebook Download
View all
Learn
View all