Vaas Montenegro
Reputation: 27
How can I update the ID column?
My question may seem easy to answer for some people but I can't find an answer.
So in SQL Server Management Studio I have a column of Ids (primary key) with an increment of 1.
By making a mistake I find myself in the situation where my id's run of 23 to 36! and not 23 to 24 ...
How to restore the default incrementing ?
Thanks in advance for you answers and best regards !
Upvotes: 0
Views: 50
Answers (1)
Max
Reputation: 7090
You can use the RESEED function to setup your identity column Check this MSDN article
Upvotes: 2
Related Questions
- how to change identity increment of column
- SQL Server 2005 : ALTER COLUMN AUTO_INCREMENT and set started ID of AUTO_INCREMENT
- Update autoincrement column in SQL server
- non-identity column auto increment
- Increment id value in SQL Server
- MS SQL update column with auto incremented value
- alter mssql column to add auto increment without t-sql
- SQL Server - how to update the ID column after inserting new records
- ID auto increment and update in SQL Server database
- auto incrementing id in sql server