SQL

copy table sql server

-- Use SELECT ... INTO:
SELECT * INTO my_table_1 FROM my_table;
-- Structure only:
SELECT * INTO my_table_1 FROM my_table WHERE 1 <> 1;

sql copy table structure

CREATE TABLE newtableName LIKE anotherTable;

sql copy table

INSERT INTO newTable
SELECT * FROM oldTable

copy table in sql

CREATE TABLE employees_copy
 AS 
 SELECT first_name, last_name, email FROM employees WHERE 1=0;