DROP a column

[DCCoolBreeze]

How can I drop a column from a table? I tried ALTER TABLE table_name DROP COLUMN( field_name ); and got an error of "Invalid Column Name"

 

[SantaMufasa]

Cool,

Try this set of syntax:

alter table <tablename> set unused column <colname>;
alter table <tablename> drop unused columns;

Dave
Sandy, Utah, USA @ 18:38 GMT, 11:38 Mountain Time

 

[DCCoolBreeze]

set getting invalid column name. now if get it on the alter table <> set unused column <>. The column does exist

 

[SantaMufasa]

Cool,

Could you please post a &quot;describe&quot; of the table followed by a literal copy-and-paste of your attempt to execute the &quot;ALTER TABLE...&quot; commands you are using?

The commands should work in all Oracle versions 8i and beyond.

Thanks,

Dave
Sandy, Utah, USA @ 19:29 GMT, 12:29 Mountain Time

 

[ddrillich]

btw, the following works as well:
alter table <tablename> drop column <colname>

Cheers,
Dan

 

[sem]

I suppose that column name may be in lower or mixed case. In this case you should &quot;doublequote&quot; it.

Regards, Dima