Log in
24
May

Quick Tip : SQL Server Reseed Identity Value

Written by Adnan Rashid. No comments Posted in: Development
Tagged with ,

DBCC CHECKIDENT can reset the identity value of the table. The syntax is as follows :

DBCC CHECKIDENT (<table_name>, reseed, <seed_value>)

After executing this statement, the next inserted record will have seed_value + 1 as value. This rule is applicable only if the table previously contained records.
In case of a table with no records, since the current [...]