title: Tables in ":memory:' database
body: <p>I have a :memory: database. I want to create 5 tables in that database. which is best normal tables/temp tables? Will the tables automatically get delete when we close the connection? </p>
  
  <p>I am planning to use sqlite_sequence table to get the last inserted id of the table. Is there any sqlite_sequence table in :memory: database?</p>