DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»

Joe Enos
Joe Enos

Posted on

SQL Server Reseed Identity

In SQL Server, IDENTITY columns make great clustered primary keys. But once in awhile, you need to manually insert values, and reset the identity value.

You have to be very careful here, but if you follow the steps from this video, you can reseed your identity column after inserting values manually.

Top comments (0)

🌚 Life is too short to browse without dark mode