1 CREATE TABLE NameOfTablePaste AS SELECT * FROM NameOfTableCopy;-- Use SELECT ... INTO: SELECT * INTO my_table_1 FROM my_table; -- Structure only: SELECT * INTO my_table_1 FROM my_table WHERE 1 <> 1;CREATE TABLE newtableName LIKE anotherTable;Select * into DestinationDB.dbo.tableName from SourceDB.dbo.SourceTable --CREATE TABLE employees_copy AS SELECT first_name, last_name, email FROM employees WHERE 1=0;