There's an option on the create table sql to do this. I believe it's create table x as select * from y;
On 4/14/05, Dennis Volodomanov <[EMAIL PROTECTED]> wrote: > Thank you Derrell and Cory, > > I can create triggers when I create the database file and I'm not using > indexes in this particular program, so that seems like the way to go. > Wouldn't a function like sqlite3_copytable(sqlite3 *pDest, sqlite3 *pSrc, > ...) be a good idea? Or it would make SQLite more complex and thus go > against the main principle? >