title: Rails - how can I view my SQLite tables?
body: <p>I would think that there would be more information on this particular topic, but here goes -- I need to be able to see what my SQLite tables in my Rails app look like. I've tried a lot of the suggestions I've seen online, but they all give me errors, or I'm not using the right commands.</p>
  
  <p>Here's what I've been trying</p>
  
  <pre><code>rails db 
  </code></pre>
  
  <p>(goes into sqlite db)</p>
  
  <pre><code>sqlite&gt;.table
  </code></pre>
  
  <p>(shows relevant table)</p>
  
  <pre><code>sqlite&gt;select * from table1;
  </code></pre>
  
  <p>Receive error:</p>
  
  <pre><code>Error: unknown command or invalid arguments:  "select". Enter ".help" for help
  </code></pre>
  
  <p>I've been trying to figure out why this won't work, but I'm a bit stumped.</p>