title: How do I return a list of all column titles in a table in SQLite?
body: <p>I have a 20-or-so column table 'Contacts' in a Contacts.sqlite file.  I use the Mac Terminal to interact with it, and am writing a program that will perform certain actions based on the number of columns in the table, as well as the name of each column.</p>
  <p>Thus, I need to perform some sort of query that will return a list of all my column titles.</p>
  <p>I have found various recommendations that look like some version of this:</p>
  <pre><code>SELECT column_name
  FROM information_schema.columns
  WHERE table_schema = 'Schema' AND table_name = 'Table_Name'
  </code></pre>
  <p>but it almost always returns an error saying there is &quot;no such table: information_scheme.columns&quot;.</p>