Copy Table structure and data

Hi,
I have one table named "table2".
I wanted to create one new table "table1" having the exact data
structure of "table1".
In Oracle we can do like,
create table table1 as
select *
from table2;

Pls tell the query for SYBASE

Regards,

wrote in message

> Hi,
> I have one table named "table2".
> I wanted to create one new table "table1" having the exact data
> structure of "table1".
> In Oracle we can do like,
> create table table1 as
> select *
> from table2;
>
> Pls tell the query for SYBASE
>
> Regards,

Offhand, you have to set the database (rough equivalent to Oracle schema)
option to allow the "select into" option. Then you can

select * into new_table from old_table

And then you should do a backup since this is a minimally logged operation.
(And turn off the option if it is unneeded.) A problem is that new_table
will NOT inherit any check or rule constraints nor any indexes. The column
definitions will not be for a usertype (if old_table used any) but for a
base type.