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

sap-ase

Solution

It is possible using `select into`!

Check more info HERE!

Problem

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?

Original source