title: How to update table in sqlite?
body: <p>I have two table first is "TABLE_SUBJECT" and second is "TABLE_CHAPTER".Now i want to<br>
  add some column and delete previous. My question is that how to do that. i try to update but<br>
  it display previous not new. I need to delete previous and update table with new column.<br>
  I change version number but it not working. Please give me hint or reference.  </p>
  
  <p>Here is my some code of SQLite:  </p>
  
  <pre><code>@Override
  public void onCreate(SQLiteDatabase database) {
  
      database.execSQL(DATABASE_CREATE);
      database.execSQL(DATABASE_CREATE1);
  
  }
  
   @Override
  public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
      // TODO Auto-generated method stub
      Log.w(MySQLiteHelper.class.getName(), "Upgrading database from version "
              + oldVersion + " to " + newVersion
              + ", which will destroy all old data");
      database.execSQL("DROP TABLE IF EXISTS " + TABLE_SUBJECT);
      database.execSQL("DROP TABLE IF EXISTS" + TABLE_CHAPTER);
      onCreate(database);
  }
  </code></pre>