There's always "CREATE TABLE ... AS ...", but not everybody is happy with the column names and types it creates.
--- Dennis Volodomanov <[EMAIL PROTECTED]> wrote: > 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 > > > > > > __________________________________ Do you Yahoo!? Make Yahoo! your home page http://www.yahoo.com/r/hs