Re: Copy table
Hi Stephane,
try this:
INSERT INTO database2:table
SELECT * FROM database1:table
Tschuess,
Dirk
"Stephane Magnan" <stephane.magnan@eur.autodesk.com> wrote in article
<5c2tfr$pu1@cssun.mathcs.emory.edu>...
> Hi all,
>
> I'd like to know how do I do to copy one table from one database to
> another database (database has a different name, but not the table).
>
> I cannot drop the target database, because it already has some
tables.
>
> Thanks in advance
>
> Stephane
>
>