Does anybody be aware of SQL to obtain a listing of table names via code in Android? I understand .tables will it through command spend but this does not sort out code. Could it be anything related to the meta-data, etc.?

Just needed to perform the same. This appears to operate:

public ArrayList<Object> listTables()
        ArrayList<Object> tableList = new ArrayList<Object>();
        String SQL_GET_ALL_TABLES = "SELECT name FROM " + 
        "sqlite_master WHERE type='table' ORDER BY name"; 
        Cursor cursor = db.rawQuery(SQL_GET_ALL_TABLES, null);
        if (!cursor.isAfterLast()) {
            do {
            while (cursor.moveToNext());
        return tableList;

First got it:

SELECT * FROM sqlite_master WHERE type='table'