http://www.sqlite.org/faq.html#q13
Hi, SQLite FAQ recommends creating temp tables and copying the data from the original table into it then deleting the old table then recreating the old table (with the desired new column) then copying the data back and deleting the temp table. On 19/06/06, Anish Enos Mathew <[EMAIL PROTECTED]> wrote:
Hi all, Any body knows how to use ADD [COLUMN] in alter table command? I want to add a new field to my table. Can "modify " be used with alter command as in SQL? The information contained in, or attached to, this e-mail, contains confidential information and is intended solely for the use of the individual or entity to whom they are addressed and is subject to legal privilege. If you have received this e-mail in error you should notify the sender immediately by reply e-mail, delete the message from your system and notify your system manager. Please do not copy it for any purpose, or disclose its contents to any other person. The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of the company. The recipient should check this e-mail and any attachments for the presence of viruses. The company accepts no liability for any damage caused, directly or indirectly, by any virus transmitted in this email. www.aztecsoft.com