create duplicate table or backup table or copy table in SQL queries
SQL Server
Select * into backup_employee from employees;
Oracle
Create table backup_employee as select * from employees;
MySQL
CREATE TABLE employees_new LIKE employees;
INSERT employees_new SELECT * FROM employees;
POSTGRESQL
CREATE TABLE employees_new AS SELECT * FROM employees;
Advertisements
