Re: [sqlite] Primay key trait is lost when copying across tables

2006-10-06 Thread Dennis Cote
Carradine wrote: Hello, I am attempting to simply copy a table with data from one database to abother database with the command: attach database 'DB.db3' AS V1 CREATE TABLE Table1 AS SELECT * FROM V1.Table1 The creation of the table, and the copying of the data works great. However, my ID

[sqlite] Primay key trait is lost when copying across tables

2006-10-06 Thread Carradine
Hello, I am attempting to simply copy a table with data from one database to abother database with the command: attach database 'DB.db3' AS V1 CREATE TABLE Table1 AS SELECT * FROM V1.Table1 The creation of the table, and the copying of the data works great. However, my ID field from the