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