Donald, On Sun, Dec 2, 2012 at 7:22 PM, Donald Griggs <dfgri...@gmail.com> wrote: > Regarding: > > *How do I do that? > I thought that simply using ".backup/.restore" will give me what I want, > but it gives me a file in internal format. > What I am trying to do is do make a text file which gives me all SQL command > that was issued (CREATE TABLE and INSERT) than fix the particular CREATE > TABLEu. > > and then load this file back into the db. > All this will be done in the console (command prompt) window. > > Do I need to use ".dump/.load" commands for that?* > > It does seem the ".dump" command in the sqlite command shell program does > just what you're asking. The ".load" command, though, loads program > extensions -- the ".read" command is the proper inverse of the .dump.
OK. > > 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. Am I right? Thank you. > > http://sqlite.org/sqlite.html > _______________________________________________ > 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