Create a duplicate table from another table in Sql

Here is simple Sql query to achieve this:

SELECT * INTO NewTab FROM  AlreadyExistingTable

Note:

here, Newtab = name of new table you want to create 

and, AlreadyExistingTable= name of table of which you want to make duplicate copy.


Enjoyyyyy..... :)