Copy Between the tables

Below statement  will just copy the column structure only not the data itself

Select * in to new_table from old_table where 1=2

Select * in to new_table from old_table where 1=0

Below statement  actually copy the data between the tables

Select * in to new_table  from old_table where 1=1

Select * in to new_table from old_table where 2=2