update auto incremented id in consecutive way

[ripa saha]

Hello Everybody,

I want to know , are there any way to make auto incremented field in consecutive way when I am deleting a record. My requirement is below:-

id sequence before delete
{1 , 2 , 3 , 4 , 5}

Now I deleted id 3 , then in general format , id sequence will be like below
{1 , 2 , 4 , 5}

But I want , When id 3 will be deleted then id 4 will be automatically shifted to id 3 and 5 in 4.
{1 , 2 , 3 , 4}

Thanks id Advance