> 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 schema with the same data (in the same database) No indexes however
