Copy data from one table to another table

The following is the query to copy the data from one table to another table.

select * into employee2 from employee1

Here Table employee1 is existing table and take backup in another table named : employee1. It will automatically will create the another table employee1 with the same structure.