Thanks! But it will take a long time if the table have a large number of rows.
I hope that SQLite will support "Alter Column" in next version!
- Original Message -
From: "Scott Hess" <[EMAIL PROTECTED]>
To:
Sent: Monday, May 28, 2007 10:38 PM
Subject: Re: [sq
In case it wasn't obvious, the "more complicated way" would probably
be something like:
BEGIN;
ALTER TABLE RENAME MyTable TO MyTableOld;
CREATE TABLE MyTable (
SameColumn INTEGER,
NewColumn TEXT
);
INSERT INTO MyTable SELECT SameColumn, OldColumn FROM MyTableOld;
DROP TABLE MyTableOld;
COMMIT;
AFAIK SQLite does not have such functionality.
Please see http://sqlite.org/lang_altertable.html . So you have to do it
in a bit more complicated way.
Regards, Dennis
Xeepe Phone Solution Team
http://xeepe.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: M
3 matches
Mail list logo
