CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl;
Select * into new_table from [database].[schema].[old_table]