It creates a new table in
the destination, so if any table having same name in destination, then drop and
continue, otherwise it throws error.
-- Created
table with Primary Key
CREATE
TABLE MyOrdersPrimary
(
OrderId
int PRIMARY
KEY NOT
NULL,
ProductName varchar(20)
);
-- Inserted
some records
insert
into MyOrdersPrimary
values (1,'Samsung')
insert
into MyOrdersPrimary
values (2,'Nokia')
select
* from
MyOrdersPrimary
-- COPY THE
(TABLE + DATA).
Select
* into
MyOrdersPrimaryCopy from MyOrdersPrimary
Note: the above wont copy the
primary key to the copy table if you use SELECT INTO STATEMENT, only it
copies table and data.
To Overcome the ABOVE
problem:
If you want the complete
Table structure,
CREATE Table by using source
table script and then use "INSERT INTO"
to copy data.
Thanks :)