Dropping Columns

[gaegoori]

I'm not sure about this, but can you drop a column or columns from tables in 8i? I forget.... what's the command?....would effect any constraints?

[pando]

alter table xxx drop column yyyy;

[gaegoori]

Thank you...I knew that....=P

[gaegoori]

other questions related to dropping columns.

ALTER TABLE table_name SET UNUSED COLUMN column_name;

what's the purpose of this unused column?.... can I bring this back as used column?....how do I see this unused column or bring it back to where it was before?

Is there an advantage of using unused column instead of dropping a column?