On Oct 8, 2012, at 10:12 PM, Richard Hipp <d...@sqlite.org> wrote: > the only ALTER TABLE functions supported are those that can be > done in O(1) time.
Out of curiosity, does 'add column not null default' modify the data or just the table definition? For example: create table foo( x, y ); insert into foo values( 1, null ); alter table foo add column z not null default 'z' ; select * from foo; > x|y|z > 1||z _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users