Create one table from another with similar structure and existing data.

Here is a simple statement that can create a similar SQL Table from an existing one without mentioning the column names
or if you mention the column name, the new table with those columns only will be created and data will be populated in the new table as well, here we go :

select * into newtablename from oldtablename

mostly needed for temp tables or tables for testing.