This is not a bug. The 'primary key' qualification is a constraint; it is not part of the type. This is pretty clearly stated in the docs for the 'create table' statement.
You can get more column info with 'pragma table_info(tbl_name)', but that doesn't give you all the column info, and it doesn't give you any table constraints. In your case, probably the best way to duplicate or alter a table is to get the 'create table' statement from sqlite_master, change the table name, add or delete rows, and then execute the altered statement. That will preserve types and constraints. Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
