SELECT * FROM table WHERE type=‘sqlite_master’返回Android Pie中sqlite中的元数据表

// 获取SQLite数据库实例
SQLiteDatabase db = SQLiteDatabase.openDatabase("path_to_database", null, SQLiteDatabase.OPEN_READONLY);

// 执行查询语句
Cursor cursor = db.rawQuery("SELECT * FROM sqlite_master WHERE type='table'", null);

// 遍历结果集
if (cursor != null && cursor.moveToFirst()) {
    do {
        // 处理每一条记录
        String tableName = cursor.getString(cursor.getColumnIndex("name"));
        String tableType = cursor.getString(cursor.getColumnIndex("type"));
        // 其他字段...

        // 输出结果或进行其他操作
        System.out.println("Table Name: " + tableName);
        System.out.println("Table Type: " + tableType);
        // 其他字段...
    } while (cursor.moveToNext());
}

// 关闭游标和数据库连接
if (cursor != null) {
    cursor.close();
}
db.close();