The ease of doing this depends on which version of Oracle 8 you are running. Oracle 8.0.x doesn't support the drop column command, so you will have to drop and recreate the table in order to eliminate the column(s).
If you have Oracle 8i you can do this more easily. The syntax of the command is
alter table table_name drop column column_name;
You don't have to set the column values to null first.
You should also be aware that you may inadvertently drop other things, such as indexes, that are defined on the column being dropped. If you have a multi column index that includes the dropped column, you will lose the entire index, even though it's very possible that you might prefer to redefine the index with all remaining columns after the drop. If this is the situation you will have to recreate the index from script.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.