How to get a tables columns arraylist on Android?

Question

I am after a code to get the available column names of a table in Android?

I looked around and didn't find anything.

Answer 1

This is a simpler way:

Cursor ti = db.rawQuery("PRAGMA table_info(mytable)", null);
if ( ti.moveToFirst() ) {
    do {
        System.out.println("col: " + ti.getString(1));
    } while (ti.moveToNext());
}

Answer 2

The simplest way I've implemented.

Cursor cursor = db.rawQuery("SELECT * FROM " + tableName + " LIMIT 1", null);
String[] colNames = cursor.getColumnNames();

Any better suggestion are welcome.