Just wondering, is there any mechanism to help me achieve that functionality or should I go the DROP, CREATE, SELECT and INSERT path?
Thanks, Dennis -----Original Message----- From: Dennis Volodomanov Sent: Wednesday, April 13, 2005 10:14 AM To: sqlite-users@sqlite.org Subject: [sqlite] Copying a table between databases Hello all, What is the best way to copy (not move) a table between an existing database and a blank, attached database using SQLite v3? The COPY command is gone, what else can I use? Thank you. Dennis