What's the default order of a table in a database?
DorbsFeb 20 2013 — edited Feb 22 2013I ask because our warehouse system uses system codes taken from a table called SYS_CODE. When a user selects a drop down menu to select one of the system codes, the most frequently used one happens to be right at the bottom so they have to scroll all the way down. I think in writing this I may have answered my own question as it just seems to be the order they were created in the table (i.e the date/time they were created) is the order in which they show in the drop down list. However, would changing the create_date_time then push this to the top of the table when I look in it, or is it simple a case of once it's received a row number, that's it?
Or is there another way of pushing one record to the top of the table?