title: When does SQLiteOpenHelper onCreate() / onUpgrade() run?
body: <p>I have created my tables in my <code>SQLiteOpenHelper</code> <code>onCreate()</code> but receive</p>
  
  <pre><code>SQLiteException: no such table
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SQLiteException: no such column
  </code></pre>
  
  <p>errors. Why?</p>
  
  <blockquote>
    <p><strong>NOTE:</strong></p>
    
    <p>(This is the amalgamated summary of tens of similar questions every week. Attempting to provide a "canonical" community wiki question/answer here so that all those questions can be directed to a good reference.)</p>
  </blockquote>