
April 14th, 2004, 10:26 AM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
how to copy a table , complete
i searched the forums for an answer , and didnt
find exactly what im looking for .. so heres the
question ..
i have a table called mytable , i want a script
to copy it completely to a table called mytable2
i also want the script do drop mytable2 if
it already exists and then copy mytable.
what commands do i use ?
the INSERT command can only insert data
into an existing table but i cant seem to make
it create the table as well .
next step : can a script be made to copy
a whole DB ? without using external tools ?
thanks in advance for any help .
|