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) :

view plain print about
1<cfquery datasource="#request.dsn#" name="dupTable">
2DROP TABLE backup_table
3</cfquery>
4<cfquery datasource="#request.dsn#" name="dupTable">
5CREATE TABLE backup_table SELECT * FROM data_table
6</cfquery>