title: Is there an SQLite equivalent to MySQL's DESCRIBE [table]?
body: <p>I'm just getting started learning <a href="http://en.wikipedia.org/wiki/SQLite" rel="noreferrer">SQLite</a>. It would be nice to be able to see the details for a table, like MySQL's <code>DESCRIBE [table]</code>. <code>PRAGMA table_info [table]</code> isn't good enough, as it only has basic information (for example, it doesn't show if a column is a field of some sort or not). Does SQLite have a way to do this?</p>