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