Re: [sqlite] Re: How to change or add fields to a table ?

2007-02-27 Thread Stef Mientki
thanks Igor, for the fast answer. (should have found that myself ;-) But there's a strange thing here I don't understand: somewhere on the ALTER TABLE documentation it says: "to rename or add a new column ..." My English isn't too well, but from the rest of the text I don't understand how I

[sqlite] Re: How to change or add fields to a table ?

2007-02-27 Thread Igor Tandetnik
Stef Mientki <[EMAIL PROTECTED]> wrote: Are there SQL commands to add or change the fields of an existing table, or should the table completely be rebuild ? Some limited changes may be done with ALTER TABLE statement: http://www.sqlite.org/lang_altertable.html For anything else, you would