title: How can I list temporary tables/views in SQLite?
body: <p>I have a function which attempts to drop a view and rebuild it whenever a new database is attached to the connection. The problem (well, more of an annoyance) is that the first time it tries to drop a non existent view. Since there is a permanent table with the same name as the view I get the sqlite error: <code>use DROP TABLE to delete table Albums</code>. Therefore, I would like to query the database to check if the view exists before attempting to drop it.</p>
  
  <p>Note: the current query already uses <code>DROP VIEW IF EXISTS</code> and that does not solve the problem. Also, I checked <code>sqlite_master</code> and there doesnt appear to be any references to temporary tables/views.</p>