Hello everyone..
If i have sql table with 5 rows and identity ID column..
RowName | ID
Row1 1
Row2 2
Row3 3
Row4. 4
Row5 5
Let say that i delete row4
Then i add Row6 the id Wil be 6
But if i delete Row4 then
Row6 ID will remind 6
And Row5 ID will remind 5..
I want if i delete Row4
Row5 ID will update to ID 4
And Row6 update to ID 5
Help please
Thank you so much