Reset identity
- Identity property in MSSQL server auto increment column value.
- When we remove rows identity column continues with incerment value, but sometimes we need reset identity to predefined value.
- We have three choices:
- DBCC CHECKIDENT
- Drop and Add the column
- Drop and Create the table
DBCC CHECKIDENT ( <table name>,RESEED,<new value>)