Re: [sqlite] exact copy of an existing Table

2005-02-10 Thread Chris Schirlinger
> SQLiters: > what would be the most efficient method for creating an exact copy of an > existing table with all the columns and data of the existing table? You could just do this from commandline in SQL like so: CREATE TABLE newTable AS SELECT * FROM oldTable; That makes a new tables, same

[sqlite] exact copy of an existing Table

2005-02-10 Thread Uriel_Carrasquilla
SQLiters: what would be the most efficient method for creating an exact copy of an existing table with all the columns and data of the existing table? Regards, Uriel_Carrasquilla