How do I create a copy of a Sybase table with data?

I know an instruction in oracle that copies structure and data.

create table mytable1 as select * from mytable;

      

But how do you do the same with Sybase ASE ?

+3


source to share


2 answers


Use is possible select into

!



Check out more information HERE !

+5


source


In Sybase ASE 16, the syntax for data and copy structure

SELECT field1, field2 INTO NewTable FROM OldTable



For copy structure only

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

0


source







All Articles