[sqlite] create table {table-name} as select.... table definition is imperfectly cloned

[Tim Romano]

CREATE  TABLE "main"."proto" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT
NULL , "name" TEXT)
CREATE  TABLE "main"."clone"  as select * from PROTO

The primary key of table CLONE is defined as "INT" not "INTEGER".

Regards
Tim Romano
Swarthmore PA
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users