> These newly added features were long requested as well, and although > ALTER TABLE is indeed an important feature too, there are probably > other issues that require more attention right now. > > In any case, there is an entry on the FAQ section that shows you how to > do something like ALTER TABLE. It's not ideal because it copies the > entire table twice, but it's better than nothing, I suppose:
The workaround for ALTER TABLE is not useable in SQL-code generating environments. These kinds of environments gain in importance. Not only in Model Driven Architecture, but also, I think it is possible in Open Office there will be GUI's which generate SQL code. > > http://www.sqlite.org/faq.html#q13 > > Cheers, > > -- > Tito