title: Add new Table in sqlite database
body: <p>I have an question.</p>
  
  <p>I have only one table in my database</p>
  
  <pre><code>@Override
      public void onCreate(SQLiteDatabase db) {
          db.execSQL( "CREATE TABLE books (_id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT, author TEXT,isbn TEXT,city TEXT);");
          Log.v("onCreate-------","called onCreate"); 
  
      }
  </code></pre>
  
  <p>here:-</p>
  
  <pre><code>sqlite&gt; select * from books;
  </code></pre>
  
  <p>also working fine.</p>
  
  <p>but i want to add new table so i am trying to add here :-</p>
  
  <pre><code>@Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
          android.util.Log.w("books",
          "Upgrading database, which will destroy all old data");
  
          //db.execSQL("ALTER TABLE myallbooks ADD COLUMN city2");
          db.execSQL("CREATE TABLE myfields (author TEXT,isbn TEXT,city TEXT);");
  
  
  
          Log.v("onUpgrade-------","called onUpgrade with alter"); 
      }
  </code></pre>
  
  <p>after changing the version number i run the app but i did not found the table any where.</p>
  
  <blockquote>
    <p>sqlite> select * from myfields;</p>
  </blockquote>
  
  <p><code>Error:-no such table :myfield.</code>..................why it is not creating</p>