Jun 14, 2021Reset sequence or primary key after delete in SQL serverWhen you delete some rows from a table for whatever reason, there might be a gap in your ID or primary key upon further insertion of data. You can reset this to start from a number of your choice, but you got to be careful about two things: a. Make…Sql Server Primary Key1 min read