Re: really dumb oracle newbie question:

Ralf Sandner <r.sandner_at_system-design.com> wrote in article <34335a2b.5826044_at_proxy>...
> i feel like a complete dork: i just can't figure out the correct
> syntax to delete a column from an existing table...
HA HA! You only feel like a dork. You CAN'T drop a column using ALTER TABLE! Only add them.

But, you can create a new table with just the columns you want with: CREATE TABLE blick SELECT col1, col2...
drop the old one and rename the new one to the old name.

Piece of pie. Easy as cake.

• Dan Clamage