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>

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

alter table <tablename> drop column <columnname>

Rename a Column in a Table

Leave a Reply

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

sixty one − = 52