"ed" <[email protected]> wrote in message news:[email protected] > I guess i was assuming the command "create table x as select * from y" > should preserve column constraints
Well, it can't, in general. Nothing says that a column in the newly created table must correspond to a column in existing table. Consider: create table x as select 1, a, b+1, c+d from y; What constraints should be placed on the four columns of table x, and why? Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
