tableExists method

Future<bool> tableExists(
  1. String tableName
)

Implementation

Future<bool> tableExists(String tableName) async {
  try {
    var db = await getOpenDatabase();
    // final result = await db.rawQuery(
    //   "SELECT name FROM sqlite_master WHERE type='table' AND name = ?",
    //   [tableName],
    // );

    final result = await db.query(
      'sqlite_master',
      where: 'type = ? AND name = ?',
      whereArgs: ['table', tableName],
    );

    return result.isNotEmpty;
  } catch (e) {
    print('[ERROR] tableExists($tableName): $e');
    return false;
  }
}