0

I would like to know how can i check if a column name exists in a SQlite database table in Flutter. I am using this method, i would like to know if it is a good way to do it.

String table_name = 'school'; // INSERT TABLE NAME HERE
String column_name = 'vote'; // INSERT COLUMN NAME HERE

var data = await db.rawQuery('PRAGMA table_info($table_name);');

bool exists = false;
for (int i = 0; i < data.length; i++) {
print("Contains $column_name: ${data[i].containsValue(column_name)}");

 if (data[i].containsValue(column_name)) {
     exists = true;
     }
}

 if (exists) {
   print("The column $column_name exists!");
   } else {
   print("The column $column_name does NOT exists");
   }

print(data);
iocomxda
  • 73
  • 8

0 Answers0