SEARCH


 


Drop a Column from a Table

It is possible to drop any column from an Oracle table by using the following 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>