title: Flutter - Modify Sqlite table without deleting database
body: <p>I am using Sqlite database in Flutter by using sqflite plugin. Following the below mentioned links I am able to successfully create database and perform CRUD operations in it.</p>
  
  <p><a href="https://pub.dartlang.org/packages/sqflite" rel="noreferrer">Sqflite Plugin</a></p>
  
  <p><a href="https://www.youtube.com/watch?v=1BwjNEKD8g8&amp;list=PLlxmoA0rQ-Lw6tAs2fGFuXGP13-dWdKsB&amp;index=25" rel="noreferrer">Sqflite Tutorial - Youtube Playlist</a></p>
  
  <p>The problem is, Once the database is created I cannot modify old tables. In order to get a new column in "tabEmployee" table, I must delete the database and recreate it.</p>
  
  <pre><code>void _onCreate(Database db, int newVersion) async {
      await db.execute(
          "CREATE TABLE tabEmployee($idPk INTEGER PRIMARY KEY, employeeName TEXT)");
    }
  </code></pre>
  
  <p>What should I do in order to modify previously created table in sqflite without deleting database ?</p>