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 ?
Use is possible select into !
select into
Check out more information HERE !
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