How can I create a copy of an Sybase table with data?

Question

I know the statement in oracle which copies the structure and the data.

create table mytable1 as select * from mytable;

But how to achieve the same in Sybase ASE?

Answer 1

It is possible using select into!

Check more info HERE!

Answer 2

In Sybase ASE 16 the syntax for copying the data and structure is

SELECT field1, field2 INTO NewTable FROM OldTable

If you want to copy only the structure use this

SELECT field1, field2 INTO NewTable FROM OldTable WHERE 1=0