Answers for "sql copy database"

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;

Posted by: Guest on May-08-2021

copy table db

USE database;

CREATE TABLE newTable LIKE oldTable;

INSERT INTO newTable SELECT * FROM oldTable;

Posted by: Guest on July-08-2021

Code answers related to "sql copy database"