Re: [Q] Make a table which has same structure.

Try :

create table newschema.newtable as select * from currentschema.currenttable;

or if you want no rows in the new table :

create table newschema.newtable as select * from currentschema.currenttable where 1=2;

Regards
David Russell

kimcd_at_shinbiro.com wrote in message <35a02116.429424_at_news.shinbiro.com>...
>Hi,
>I have made a table.
>And I want to make another table which has same structure but owner
>and table name is different .
>
Received on Sun Jul 05 1998 - 13:26:15 CDT