SEARCH


 


Rename a Column in a Table

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>