[Solved] how to create an sql table without using create keyword? [closed]


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]