On Sun, Jun 27, 2010 at 07:41:48PM -0400, Sam Carleton scratched on the wall:
> 1: Create the new table with a different name: target_table2 with the changes > 2: Do an insert/select to insert the contents of target_table into > target_table2 > 3: Drop target_table > 4: Modify the master table to change the name of target_table2 to > target_table > > According to the FAQ, sqlite_master is read-only. Is there any to pull of > this trick? You can do this with "PRAGMA writeable_schema", but I think the real answer you're looking for is ALTER TABLE ... RENAME. -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
