For example this is a table named as Emp and you create a table named as Emp_Copy
EmployeeID  EmployeeName  Age   Gender  
1001        Henry         54    Male    
1002        Tina          36    Female  
1003        John          24    Male    
for selecting all columns
SELECT * INTO Emp_Copy FROM Emp;
for selecting some columns
SELECT EmployeeID,  EmployeeName ,Age INTO Emp_Copy FROM Emp;
0
solved how to create an sql table without using create keyword? [closed]