Re: Delete column(s) from a table

The SQL statement exists Oracle just chooses not to support this function like DB2/400 and others have done.

In article <336F92E5.7ED0_at_att.com>, Allen Kirby <akirby_at_att.com> writes:
|> Patrick C. K. Wu wrote:
|> >
|> > Hi all
|> >
|> > Could anyone tell me how to delete column(s) from a table using SQL
|> > statement?
|>
|> What you would like to do is this: alter table drop column <column>;
|>
|> Unfortunately, that command doesn't exist. You have to copy the table
|> It's really a hassle so we avoid it by just ignoring the column and...
|> --
|> ---
|> Allen Kirby AT&T ITS Production Services
|> akirby_at_att.com Alpharetta, GA.
 

-- 
Kenton Milligan
DB2/400 Development 
IBM Rochester-AS/400 Division
kmill_at_vnet.ibm.com
GO HAWKEYES!!
(opinions stated are not necessarily those of my employer)