Hi all, I have read that it’s not possible to alter an existing table to add a primary key, this is causing me some troubles. I have a table “My_main_tbl” from where I want to take a subset of rows in order to create a new table with the exact same columns.
CREATE TABLE My_second_tbl AS SELECT * FROM My_main_tbl WHERE topic = ‘aviation’ My problem is that is on my original table the column QID is a primary key but on my new created table the column QID is not a primary key anymore, in fact I have no primary key at all. Is there any way of doing this without explicitly specifying each column, and without going into doing the copy table as explained in http://www.sqlite.org/faq.html#q11 ? As far as I can read over the net SELECT INTO is not supported in sqlite, right? Thanks for your help, Fabou _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
