SQL Server CTAS

select * 

into new_tab 

from tab;