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. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of YAN HONG YE [yanhong...@mpsa.com] Sent: Thursday, March 29, 2012 12:43 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] how to add time in a new column sqlite> alter table dzh add mtime NOT NULL DEFAULT CURRENT_TIME; Error: Cannot add a column with non-constant default _______________________________________________ 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