"Alter table" syntax command ?

Hi all.

I'm an horrible newbie on Oracle and I don't have any docs. I altered a table with the command :

alter table MY_TABLE add NEW_COLL number;

It was a bad idea and now I'm trying to drop this NEW_COLL from my table. I used several commands but all failed because of bad syntax.

What is the command for simply drop a column from a table ? Received on Mon Jun 22 1998 - 12:03:59 CDT