在sqlite中如果想查询某个表的所有字段与属性。
输入语句:
//user是表名
pragma table_info(user);
android 相关代码,测试可行:
MysqliteHelper mysqliteHelper = new MysqliteHelper(context);
SQLiteDatabase db = mysqliteHelper.getReadableDatabase();
Cursor cursor = db.rawQuery("pragma table_info( org_user )", null);
while (cursor.moveToNext()) {
String[] columnNames = cursor.getColumnNames();
for(String name:columnNames){
Log.w("tag", "name=="+name+"==value=="+cursor.getString(cursor.getColumnIndex(name)));
}
}
cursor.close();
db.close();
在sqliteexpert中的效果: