Re: [sqlite] ALTER table command

Assuming a schema like: create table t1 (a,b); Add another column, "c" alter table t1 add column c; -Clark - Original Message From: Anish Enos Mathew <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, June 19, 2006 12:42:46 AM Subject: [sqlite] ALTER ta

Re: [sqlite] ALTER table command

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, Anis

[sqlite] ALTER table command

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

[sqlite] ALTER TABLE Command restrictions

Hi, I was just playing with ALTER TABLE, and it appears that you can only add 1 column with each command. Is this correct? If so, how hard would it be to enable adding multiple columns with the same command? Thanks, Robert Foster General Manager Mountain Visions P/L http://mountainvisions.com.