On Aug 8, 2005, at 5:14 AM, Matthew Gertner wrote:
I'm wondering if there is a way to get information about the format of tables in an existing Sqlite database. Specifically, I would like to get the list ofcolumns and the data type of each column.
Check out the table_info PRAGMA on this page: <http://sqlite.org/pragma.html>