Cursor ti = db.rawQuery("PRAGMA table_info(mytable)", null);
if ( ti.moveToFirst() ) {
do {
System.out.println("col: " + ti.getString(1));
} while (ti.moveToNext());
}
try {
Cursor c = db.query(tableName, null, null, null, null, null, null);
if (c != null) {
int num = c.getColumnCount();
for (int i = 0; i < num; ++i) {
String colname = c.getColumnName(i);
}
}
} catch (Exception e) {
Log.v(tableName, e.getMessage(), e);
e.printStackTrace();
}