On 30 Sep 2014, at 12:32pm, dd <[email protected]> wrote: > My db already there in production. I have to do it programmatically. > > Can it be done with any sqlite apis/pragmas.
Sure. But you do need to drop the table at one point so nothing should be trying to use it. Depending on how your indexes, triggers and foreign keys are defined you can do something like CREATE TABLE newVersion (<put in correct table definition with collations here>) INSERT INTO newVersion SELECT * FROM originalName DROP originalName ALTER TABLE newVersion RENAME TO originalName You may then have to recreate any indexes triggers and foreign keys. Again, don't forget to take a backup before messing with anything. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
