Re: a question about creating a new table

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 01 Dec 1999 20:18:58 +0800
Message-ID: <38451232.3A12@yahoo.com>

mary_sun_at_hotmail.com wrote:
>
> Hi, there. I need some suggestion about creating a new table. I want
> to create a new table named A which has the same structure that an
> exist table named B has. I don't want to copy the define part of the
> table B to create the table A. I don't want use CREATE A AS SELECT *
> FROM B to create the table A. Is there any other easy way to create
> the table A?
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

See the other post...

Also "exp table=blah rows=n"

and you can 'strings' that file to get the DDL. --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 01 1999 - 06:18:58 CST