MSSQL
Reset Auto-generated Primary Key(RESEED) at MS SQL Server
In this blog, I am going to discuss how to clean a table so that your table auto-generated primary key start from 1. Technique 1: We can use TRUNCATE to drop your table and generate a fresh one. It will remove all your table data as well as your auto-generated primary Read more…