On 29 March 2012 12:36, Black, Michael (IS) <michael.bla...@ngc.com> wrote: > You'll need to export the table and data. Change the SQL to what you want. > Then import again. > > Does the shell have ability to name the columns on the insert statements > from the .dump to make this easier? I don' t see anythinig offhand that > seems to do that.
Or use ALTER TABLE RENAME TO... and INSERT INTO... viz create table t( id integer, data text ); insert into t values( 1, '1' ); alter table t rename to old_t; create table t( id integer, data text, "time" text default current_time ); insert into t( id, data ) select id, data from old_t; > > Michael D. Black > > Senior Scientist > > Advanced Analytics Directorate > > Advanced GEOINT Solutions Operating Unit > > Northrop Grumman Information Systems > Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
