How to count number of columns in a table in SQLITE?

Question

How can I count the number of columns in a table in a sqlite database in Android?

Answer 1

A query returns a Cursor which has methods like getColumnCount().

Answer 2

You can use pragma table_info(foo_table) and count the number of rows returned

Answer 3

Here is the code and it runs perfectly without any error.

public Cursor getAllTitles(){
   return db.query(DATABASE_TABLE, new String[] {
        KEY_ROWID,KEY_ISBN,KEY_TITLE,KEY_PUBLISHER},
        null,null,null,null,null);
}

Now create the following object in onCreate() method to call above getAllTitles() method.

Cursor c = db.getAllTitles();
c.getColumnCount(); //this line will give the number of columns in table.