[sqlite] what internal table contains column names in a table?

I want to write a program that generates insert & update statements for a table. what internal table would I query to get the column names in a table? -- ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] pragma table_info(tbl)

I have a table named person that contains 13 columns. pragma table_info(person) returns 13 rows of cid. I assume this is the primary key... do I need to add something to get the column name along with cid? -- No trees were killed in the sending of this message. However, a large number of