Drop column

[omran]

Hi all,
May be this is a very simple question!!
How can I drop a column from a table in Oracle SQL 7.3
Thanks

[Mr.Hanky]

I am fairly certain that the ALTER TABLE DROP COLUMN command was added in Oracle 8i. If this is the case than you have to drop and re-create the table and then selectively import your data. Take a good backup of the table first. I hope it isn’t too big.

MH

[marist89]

or...
1. rename your table to foo_old
2. create table foo ()...
3. insert into foo select f1, f2, f3 from foo_old;

[omran]

Thank you very much