COPY Table question

General

COPY Table question

If I use the COPY Table to copy a table from one database to another database (same server) and the table already exist, will it drop and recreate the table?

Thanks

Chris

2 REPLIES
Fan

Re: COPY Table question

it will give you an error "Table already exists"

--nomi

Enthusiast

Re: COPY Table question

Chris,

It will give a warning that the table already exists, and  the table will be overwritten with the copy.

RGlass