It is possible to drop any column from an Oracle table by using the following SQL alter table command:

alter table <tablename> drop column <columnname>

If you need to rename a column you can do this as well by using the following command:

alter table <tablename> rename column <columnold> to <columnnew>

How to drop a column from a table

Leave a Reply

Your email address will not be published. Required fields are marked *

thirty one − twenty one =