How to create a table from existed table.

[Gison]

I try to create a table from another existed table but always error.
Please help, does any one know what's wrong in my sentence?

=======
create table item_bak
as (select * from item);
=======

thanks a lot.
gison

[iburyak]

Try this:

select * into item_bak from item

Good Luck.

[ck9663]

I try to create a table from another existed table but always error.
Please help, does any one know what's wrong in my sentence?

=======
create table item_bak
as (select * from item);
=======

thanks a lot.
gison

if you want to create item_bak based on item's structure, EXCLUDING the data, you go:

select * into item_bak from item where 1 = 2

[Gison]

Thanks iburyak and ck9663 a lot.
I can be done.

:)