Re: [Q] How do I drop a column from a table?

Steve Crowe wrote:
>
> I am trying to drop a column from a table. I thought that I could use
> the ALTER TABLE command, but I can't seem to get it to work. I am
> using "Oracle: The Complete Reference" by Koch and Loney. It has lots
> of stuff on adding and modifying columns, but not one word on deleting
> or dropping them.

  There is no drop column option in Oracle. You can do in this way by re-creating the table again.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841