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