This query will create a table with Name Employee2 with all data and same structure of Employee table, here only those column and column data will copy which I mention in Select commandSELECT name,Country, Mobile,Salary INTO Employee2 FROM
Employee
This query will create a table with name Employee 3 by having the same structure of Employee table this query will not copy data
SELECT * INTO
Employee3 FROM Employee WHERE 1=2
If we write this query as
SELECT * INTO Employee3 FROM Employee
then it will also copy all data.