SQL help (create table)

Hello
I'd like to know if it is possible to create a table where column names are the result of a select. Something like : create table new_table (select column from table) And if yes, how do I specify data types ? Is there a default data type ? Thanks a lot Received on Mon Jun 03 2002 - 04:24:07 CDT