title: Python sqlite loop thought all tables in database
body: <p>I have 700 tables in a <code>test.db</code> file, and was wondering how do I loop through all these tables and return the table name if <code>columnA</code> value is <code>-</code>?</p>
  
  <pre><code>connection.execute('SELECT * FROM "all_tables" WHERE "columnA" = "-"')
  </code></pre>
  
  <p>How do I put all 700 tables in <code>all_tables</code>?</p>