Re: a question about creating a new table

From: <michael_bialik_at_my-deja.com>
Date: Tue, 30 Nov 1999 21:49:36 GMT
Message-ID: <821gpf$3ub$1@nnrp1.deja.com>

Hi.

I think that CREATE TABLE A AS SELECT * FROM B WHERE 1 = 2 will create a table without any data ( if that's the reason you don't want to use it ).
Otherwise I'm lost.

HTH. Michael.

In article <821g6c$3fj$1_at_nnrp1.deja.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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 30 1999 - 15:49:36 CST