如何在SQLite数据库的表中获取列的列表？

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...)I am looking to retrieve a list of columns in a