Re: how to copy the table defination

create table x as select * from y where 1 = 2;

--
Have a nice day
Michel


sachh <sachh_at_bigfoot.com> a écrit dans le message :
89m55b$t1$1_at_news.vsnl.net.in...


> 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

>

>