SQL row will automatically generate a row # but will not revert to it after deletion of that row.
When selecting “Edit Top 200 Rows” and adding another line of info to the table it works fine and automatically added a consecutive # to the “Ithgschool_Ext_ID” column.
But when I delete the newly added row, the next time I insert another new row, the consecutive # is skipped. In this case there are rows 1, 2, and jumps straight to 5.
Now, if I delete row 5, the next time I insert another row, that column will automatically generate the number 6, so it will show 1, 2, and 6.
How can I have the consecutive order show up again?