How to Duplicate a Table in MS-SQL

In MS-SQL Server, using SELECT INTO, a duplicate of an existing table can be created with a different table name. To duplicate the schema and content of a table, use:

select * into employee_new   from  employee;

If you want to create a new table replicating the schema, but leaving the table empty, you can use TOP 0:

select top 0 * into employee_new2   from  employee;