Duplicate a mySQL table with one line of SQL code
CREATE TABLE copyname SELECT * FROM originalname
Too easy!
I'm using this to make a backup of an existing table before running a scheduled data import routine (overwriting the backup_table each time by making a new copy of the original) :
<cfquery datasource="#request.dsn#" name="dupTable">
DROP TABLE backup_table
</cfquery>
<cfquery datasource="#request.dsn#" name="dupTable">
CREATE TABLE backup_table SELECT * FROM data_table
</cfquery>
It's just as easy to do it in SQL Server, too.
<cfquery datasource="#request.dsn#" name="dupTable">
SELECT * INTO backup_table FROM data_table
</cfquery>
If backup_table doesn't already exist, it automatically creates it.