Re: how to copy the table defination

From: <tandym_at_hotmail.com>
Date: 2000/03/02
Message-ID: <89lt2u$hug$1@nnrp1.deja.com>#1/1

export the table using the ROWS=N parameter and then import into new schema. This way you can get all the constraints and indices, etc.

tandym

In article <89m55b$t1$1_at_news.vsnl.net.in>, "sachh" <sachh_at_bigfoot.com> wrote:
> I want to create the table identical to other table with populating
it .
> Is there any way round to do it?
> I had tried create table x as select * from y;
> but that populates the table x also.
> i want to create only table.
> regards
> sachin
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 02 2000 - 00:00:00 CST