I have created one table which has primary key. It gets auto incremented when we add new record.
Suppose records are as follows
and I delete 3rd record from it.
Next time while adding new row , primary key will be 4 even if 3rd record is not present. I want to have it 3 instead of 4.
Primary key is unique and not null,but this soft deletion of records from table should be avoided.
How to achieve this?