Regarding: > > > > Note that you only need to .dump/.read the table(s) you want to alter. > > *Well, I don't think it's true. > 1. When I execute "CREATE TABLE" with the table name that already exists > wouldn't I get an error message? > 2. If I drop this table first I will get an error about the key constraint > as the table holds primary key for couple of tables. > * > > > I believe that simply turning off foreign key constraints will prevent the error messages.
http://sqlite.org/pragma.html#pragma_foreign_keys But perhaps there's a foreign key relationship with a rowid that requires you to re-create the entire database to ensure integrity. If not, maybe the pragma is all you need. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users