How to get a tables columns arraylist on Android?

android, java, sqlite

Solution

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());
}

Problem

I am after a code to get the available column names of a table in Android? I looked around and didn't find anything.

Original source