title: How do I check if a table exists in sqlite3 c++ API?
body: <p>I'm opening a database file and potentially creating it if it doesn't exist.</p>
  
  <p>But for some reason, this doesn't create the table.  Any ideas?</p>
  
  <pre><code>const char* sql = "CREATE TABLE IF NOT EXISTS blocks(id text primary_key,length numeric)";
  
  sqlite3_stmt *stmt;
  rc = sqlite3_prepare_v2(db_, create_table_sql, -1, &amp;stmt, NULL);
  rc = sqlite3_step(stmt);
  </code></pre>
  
  <p>I haven't got it in here by yes I'm checking the return code at each point.
  There are no errors.</p>
  
  <p>Perhaps there is a better way to accomplish this?</p>