title: How can I get the list of a columns in a table for a SQLite database?
body: <p>I am looking to retrieve a list of columns in a table.  The database is the latest release of SQLite (3.6, I believe).  I am looking for code that does this with a SQL query.  Extra bonus points for metadata related to the columns (e.g. length, data type, etc...)</p>