http://www.sqlite.org/faq.html#q13
Hi, the above link goes to an FAQ on the SQLite website stating that the ALTER TABLE command has limited functionality and recommends creating a temp table and copying everything there, dropping the original table, re-creating it with the desired changes and copying everything back from the temp table and then dropping that. This is all good when the fields(columns) are known in advance, but how would I attempt doing this without knowing the name of the fields? Any ideas? Many thanks John
