Re: Create table as select

select * from test.mytable into myspace.mytable ?

[EMAIL PROTECTED] (Maria) wrote in message news:<[EMAIL PROTECTED]>...
> 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