Peter Loveday wrote:
Greetings!
Is there any way to add or remove field(s) from a table, short of copying the entire thing to a newly created table with the desired schema?
No. See http://sqlite.org/faq.html#q13 for the closest alternative (which is basically a variant of copying the whole thing).
-Eric
