title: Is there an equivalent SELECT statement for PRAGMA table_info('mytable') in SQLite?
body: <p>Is there an equivalent SELECT statement for PRAGMA table_info('mytable') in SQLite?  Essentially, I would like to get the exact same result set as PRAGMA returns: cid, name, type, notnull, dflt_value, and pk.  Although I know of the other alternative to getting this information via the C function sqlite3_table_column_metadata, I would prefer to use a SELECT statement.</p>