LifeinAsia - 4:07 pm on Sep 7, 2010 (gmt 0)

A primary key is basically an index, so the data will be sorted according to it. Removing the index will not automatically re-order the data, so the behavior you experienced sounds right to me.

then save the table and re-open it

It sounds like the client interface you are using to open the table may have some underlying default sort that it uses, which may or may not be the order the data is stored in the table.

If you do not want the data sorted by the designated column, then adding an additional sort field, as Demaestro suggested, should get you what you want.