Creating a table from another table

This blog will describe how to create a table as it is as another table

            Copying A Table from Another Table

You can create table from another table by writing following  select statement

Select * into <new table name> from tablename

The following example creates a table with name employee1 from employee

Select * into employee1 from employee

 

When a table is created with this syntax then constraints and indexes available on existing table will not copy to new table