Sql Server: CTAS Create table as select

Creating table from another data copy only the snytax but not the data

SELECT * FROM Customers

SELECT * INTO ImpCustomers FROM Customers WHERE 1=2

SELECT * FROM ImpCustomers

O/p:

DROP TABLE ImpCustomers 

Tags: Sql Server: CTAS Create table as select,Create, Copy