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 original database is an INTEGER PRIMARY KEY, but when the table gets copied over, it only becomes an INTEGER. Am I defining my SQL statements wrong? Or am I going to have to use a CREATE INDEX call when coying over my table? -- View this message in context: http://www.nabble.com/Primay-key-trait-is-lost-when-copying-across-tables-tf2397051.html#a6684143 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
