Abolfazl

Abolfazl

  • 1.8k
  • 148
  • 61k

Reset Primary Key Column

Mar 16 2015 6:14 PM

hi

i have a table named users which have a ID column as primary key(is identity=true).

when i add some data to table everything is ok but when delete some of them,

the deleted IDs cause Irregularity in ID column.i want to reset the ID column to begin from 1 

and increment 1 per each data without remove existing data.

for example:

before delete : ID 1 2 3 4 5 6 7 8 9 

after delete : ID 1 2 4 5 8 9

what should i do???

thanks


Brought to you by:

Answers (6)