Sql Server : How to reseed identity column
- Posted by Sqltimes
- On January 2, 2016
- 0 Comments
Quick one today:
Every once in a while there comes a need to reseed identity values for some tables in our QA environment. This script has come in handy every time. There are variations to this script, but this provides a god starting point.
|
1
2
3
4
5
|
---- Reseed identity column value--DBCC CHECKIDENT(SomeTable, RESEED, 5000)GO |
For more information, please review this MSDN article.
Hope this helps,
_Sqltimes
0 Comments