title: SQLite "Drop table" error message: "SQL logic error or missing database"
body: <p>I am running a SQLite database in memory and I am attempting to drop a table with the following command. </p>
  
  <pre><code>DROP TABLE 'testing' ;
  </code></pre>
  
  <p>But when I execute the SQL statement, I get this error </p>
  
  <pre><code>SQL logic error or missing database
  </code></pre>
  
  <p>Before I run the "Drop Table" query I check to make sure that the table exists in the database with this query. So I am pretty sure that the table exists and I have a connection to the database.</p>
  
  <pre><code>SELECT count(*) FROM sqlite_master WHERE type='table' and name='testing';
  </code></pre>
  
  <p>This database is loaded in to memory from a file database and after I attempt to drop this table the database is saved from memory to the file system. I can then use a third party SQLite utility to view the SQLite file and check to see if the "testing" exists, it does. Using the same 3rd party SQLite utility I am able to run the "Drop TABLE" SQL statement with out error. </p>
  
  <p>I am able to create/update tables without any problems.</p>
  
  <p><strong>My questions:</strong> </p>
  
  <ul>
  <li>Is there a difference between a memory database and a file database in SQLite when dropping a table?</li>
  <li>Is there a way to disable the ability to drop a table in SQLite that I may have accentually turned on somehow? </li>
  </ul>
  
  <p><em>Edit:</em> It appears to have something to do with a locked table. Still investigating. </p>