title: Drop table and recreate if exist in sqflite flutter
body: <p>I want to drop table before populating with server data if exist. </p>
  
  <p>the Queries I'm trying </p>
  
  <pre><code> deleteOptionTable() async {
      final db = await database;
      db.rawDelete("Delete * from option");
    }
    dropTable() async {
      final db = await database;
      db.query('SELECT * FROM cloudnet360.db WHERE name =option and type=table');
    }
  </code></pre>
  
  <p>I have tried something like this but nothing is happening.</p>
  
  <pre><code>void _insertOption(OptionsGroupList option) async {
  
      int idd =  dbHelper.dropTable();
  
      print('DROP TABLE: $idd');
  
      PreferencesConnector myprefs= PreferencesConnector();
      String merchantid=await myprefs.readString('merchantid');
      String hashkey=await myprefs.readString('hashkey');
  
      Map&lt;String, dynamic&gt; row = {
        DatabaseHelper.columnGroupId:option.grouprowid ,
        DatabaseHelper.columnGroupName: option.groupname,
        DatabaseHelper.columnIsRequired:option.isrequired ,
        DatabaseHelper.columnMerchantId: merchantid,
        DatabaseHelper.columnMerchantHashKey: hashkey,
      };
      int id = await dbHelper.insertOption(row);
  
      print('inserted option row id: $id');
    }
  </code></pre>