Drop column from a table

I'm using Oracle 7.3.4 and have decided to move two columns from one table to another table. I would have thought I could just do an ALTER command but that doesn't seem to work and I cannot find any example for check my syntax. Here's the statement:

alter table T drop column C

I also tried without teh "column" bit but got the same results.

Can I drop a column from table?

JMH Received on Fri Jan 14 2000 - 17:04:05 CST