title: android.database.sqlite.SQLiteException: No such table exists
body: <p>I have a sample Android app in which I created a database, created a table and then inserted data into the table. The next day, on opening the Eclipse IDE and running my app through the emulator, the app suddenly gets closed, with a SQLLiteException saying <code>No such table</code>. </p>
  
  <p>My MainActivity code is as follows:</p>
  
  <pre><code>SQLiteDatabase DB = Context.openOrCreateDatabase(
          "WaterElectricityReadingDataBase.db",
          MODE_WORLD_READABLE, null);
  
  final String CREATE_TABLE = "create table if not exists "
          + TABLE_NAME + "(" + COLUMN_NAME_READING_ID
          + " integer primary key autoincrement,"
          + COLUMN_NAME_READING_MODE + " text not null,"
          + COLUMN_NAME_PASTDATETIME + " date not null, "
          + "EndDateTime date not null, "
          + COLUMN_NAME_READINGVALUE + " integer not null" + ");";
  
  DB.execSQL(CREATE_TABLE);
  </code></pre>
  
  <p>Is the table or data not persistent? Have I missed anything in the setup? </p>
  
  <p>Please correct me, thanks.</p>