Re: [sqlite] Adding/Removing fields?

2004-09-27 Thread Chan Wai Wa, Raymond
On Mon, 27 Sep 2004 22:15:58 -0700, Eric Scouten <[EMAIL PROTECTED]> wrote: > 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://sqlit

Re: [sqlite] Adding/Removing fields?

2004-09-27 Thread Eric Scouten
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

[sqlite] Adding/Removing fields?

2004-09-27 Thread Peter Loveday
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? Love, Light and Peace, - Peter Loveday Director of Development, eyeon Software