title: How to count amount of columns in sqlite from command line tool
body: <p>I am trying to count the columns from a sqlite db using the sqlite command line tool. To test it I created a sample db like this:</p>
  
  <pre><code>c:\&gt;sqlite.exe mydb.sqlite "create table tbl1(one varchar(10), two smallint);"
  </code></pre>
  
  <p>Now lets say i don't know that the table tbl1 has 2 columns, <strong>how can I find that using a query from the command line tool?</strong></p>