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]