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: [email protected] [[email protected]] on behalf of YAN HONG YE [[email protected]] Sent: Thursday, March 29, 2012 12:43 AM To: [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
