Is this possible ...

[Anon]

Can anyone tell me if it's possible to create a new table that has the same columns as one already created, although not the contents of it?

When I mean create a new table, I mean without specifying each of the column names individually, but rather just carrying the structure of the existing table across.

Thanks, Sarah.

[Anon]

create table foo as select * from bar where 1=0;

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

[Anon]

Thanks Michael, your suggestion worked. Cheers again.