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);