Column index order SQLite creates table

Question

This is the query that I use to create a table

create table site_table(
   _id integer primary key autoincrement,
   name_site text,
   url text,
   login text,
   pass text
);

I called Cursor.getColumnNames() and noticed that columns order are id, login, pass, name, url.

So, if I want a value I have to get it by the index Cursor.getString(index). Until I debugged I was messing up calling the wrong index, but now I wonder, why SQLite saves that way? Why it does not follow that way I created id, name_site, url, login and pass?

Thanks

Answer 1

So, if I want a value I have to get it by the index Cursor.getString(index)

So for example for this reason you should always use

c.getString(c.getColumnIndex("ColName")); // or better getColumnIndex(CONSTANT)

This method saves all of us and ensure that you never get wrong results. Generally this method is recommended and also storing COLUMN_NAMES as CONSTANTS in separated class is very, very useful and efficient practise.

Note: Order depends on projection i.e. select name, lastname from table

Answer 2

That data is ordered by the order your requested it in your query, not the order you created the table with. So you probably changed the order in your query that generated said cursor.