P Kishor wrote: > On Sun, Aug 2, 2009 at 10:39 PM, Igor > Tandetnik<itandet...@mvps.org> wrote: >> You don't make a copy of a table - you make a copy of the resultset >> of a SELECT statement. Columns in said resultset don't carry >> attributes like DEFAULT, even though columns in the underlying table >> may. > > Hmmm... now that you say so, I am reminded of this topic a short while > ago. Makes sense what you say Igor. However, if the "copy of the > resultset of a SELECT statement" was smart enough to bring over 'desc > TEXT', why was it not quite smart enough to bring over the 'PRIMARY > KEY' part of 'id' or the 'DEFAULT 0' part of 'num'?
'desc' and 'TEXT' are in fact properties of the resultset - see sqlite3_column_name, sqlite3_column_decltype Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users