Re: SQL help (create table)

CREATE TABLE new_table_1 AS
SELECT col_1, col_2 FROM wxisting_table;

The new columns inherit the data type

Jean-Baptiste Jacquemard wrote:

> 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
>
>

-- 
Remove '-123' (no quotes) from the e-mail address when you want to reply 
to me

-Happy Trails ;-)