You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
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