On Tue, May 31, 2011 at 5:11 PM, Fabio Spadaro <[email protected]>wrote:
> "Alter table add column" command drop data from table. > Can you keep the data or should I store the data before the alter and then > put > them in the table? > http://www.sqlite.org/lang_altertable.html says: "The execution time of the ALTER TABLE command is independent of the amount of data in the table. The ALTER TABLE command runs as quickly on a table with 10 million rows as it does on a table with 1 row." Implicit in that statement is that ALTER TABLE does not modify/delete any table data. If it did, the runtime would probably be O(N) or worse, not O(1) (as described above). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
