Jay, On Sun, Dec 2, 2012 at 12:16 PM, Jay A. Kreibich <j...@kreibi.ch> wrote: > On Sun, Dec 02, 2012 at 11:58:54AM -0800, Igor Korot scratched on the wall: >> Hi, ALL, >> ALTER TABLE <table_name> command does not support changing the field type. >> >> What is the easiest and fastest way to change the field type from >> integer to double? > > The easy, fast, and dangerous method is to edit sqlite_master directly.
;-) I thought that the word "safest" is explicit. Guess not... 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? Thank you. > >> I know it is all saved as text > > No, it isn't. That was true of SQLite 2, but SQLite 3 stores types > in their native format. > > -j > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Intelligence is like underwear: it is important that you have it, > but showing it to the wrong people has the tendency to make them > feel uncomfortable." -- Angela Johnson > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
