The method in the faq is somewhat simplistic. For example, if you have indexes or triggers associated with the table, you'll lose them. It may or may not be a big deal to reinstate them manually but be prepared to have to do that.
Or you could use one of the many third party tools that will do this safely for you while retaining all the related structures of the table being changed, such SQLiteAdmin, available at www.lcsql.com Pete lcSQL Software <http://www.lcsql.com> On Mon, Dec 3, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > How to make alterations to a table that can not be done with the ALTER > TABLE command is outlined in topic 11 of the FAQ: > > http://sqlite.org/faq.html#q11 > > You just have to make a change to a column definition rather than add or > drop columns, but the idea is the same. > > HTH, > > Gerry > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users