On 12/2/2012 1:52 PM, Igor Korot wrote:

So, does this mean that I need to drop the DB in the text file, edit
it and then re-create
it from this file?


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

Reply via email to