select * from test.mytable into myspace.mytable ?

evoradba@yahoo.ca (Maria) wrote in message news:<351fd9d6.0311201933.4b085f8b@posting.google. com>...
> Hi there
>
>
> Is there a way of creating a table in sybase like in oracle CTAS
>
> e.g.
>
> Create table MYTABLE tablespace MYSPACE as select * from
> test.mytable
>
>
> In sybase the only way that I know is bcp out create a table bcp in
> and then re name... is there a better way??
>
>
> Many tanks
> Maria