title: How does PRAGMA table_info(table-name) work in SQLite database?
body: <p>I started learning SQLite and read that I can get the column information about any table with the <code>PRAGMA table_info(table-name)</code> command without specifying column names anywhere in the file.</p>
  
  <p>How does <code>PRAGMA</code> know which columns we need for any particular table? Do we have to specify any information about the table in a bin file or environment file? </p>