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

Question

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

sybase-ase

Anil purswani Apr 10 12 at 11:15

source to share

2 answers

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

Doberon Sep 20 16 at 22:07

source to share

aF. · Accepted Answer · 2012-04-12T12:15:26+0000

Use is possible select into

!

Check out more information HERE !