How to copy table?

Started by Jeff Luabout 25 years ago2 messagesgeneral

jklcom@mindspring.com

about 25 years ago

Hi,

How can I copy a table or backup a table within a database?

#2 $(J.H.M. Dassen \(Ray\))$

(J.H.M. Dassen \(Ray\))

jdassen@cistron.nl

about 25 years ago

In reply to: Jeff Lu (#1)

Re: How to copy table?

Jeff <jklcom@mindspring.com> wrote:

How can I copy a table or backup a table within a database?

SELECT * INTO TABLE newtable FROM originaltable;

HTH,
Ray
--
I'm having trouble keeping my clever schemes separate from my sarcasm.
Wally