khandelwal g wrote:i want it to be 1,2,3,4.means 4 records starting from 1
Why do you want to do that? What's the need? It's not advisable. Generally applications does not work on single table. There are dependencies and foreign key relations. If you change a dependant column value in main table then you need to take care of other tables too.
There is no point in re-assigning the values. They are in DB and your application knows how to handle it.
Infact, primary keys most of the times are made an Identity Key to avoid any issue.
khandelwal g wrote: if i will not take statecode as a primary key,then what is the
solution for this problem.
I don't find any problem out here? What's troubling you? Rearrangement is not going to help you, so why to do it!