Re: Creating an SQL table with mixed reference and explicit column datatypes.

["sjl" <sjl_abc@xxxxxxxxxxx>]

Eftimios Pantzopoulos wrote:
  I know how to create a an SQL table with 'create table as 
(select.........)
  definition only, and how to create a table with explicit column
  data type declarations, but I can't work out how to mix the two!
  I want to be able to create a table with all the definitions
  from an existing table except for one column.
  Is this possible?


Eftimios -
Use the create table as (select.........) to create the table, then use 
ALTER Table to DROP the column you don't need.
- sjl