Satyavani

• Jul 27th, 2005

 

There are 2 ways of doing it : 
alter table"table name" drop column "column name"; 
 
This drops the column immediately. However if there is huge data and you would like to postpone the task of dropping the columns you can make the columns unused and drop the unused columns during the weekend or less peak activity time. 

Sundar_oracle

 Profile Answers by Sundar_oracle 

• Mar 16th, 2006

 

Hi,

I could not find the way to drop a column as said, will u send which is the  version to work with the same.

Regards,

K. Sundar.

djsundar@rediffmail.com

Shiv Mangal Rahi

• Jul 24th, 2006

 

Hi All,

You could drop column of a table by follwing command. And it works with all the version of oracle.

SQL> Alter table <table name> drop column <column name>;

How ever instead of dropping a column you could make it unused. And at the end of month or week you could drop all the unused columns. This is due to avoid some risks.

To make a column unused you could have following command:

SQL> Alter table <table name> set unused column <column name>;

To drop unused columns you could use the following command:

SQL> Alter table <table name> drop unused columns;

You could also drop all the unused columns of a schema as well.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 

 If your oracle version is 9i or above then only you can drop a column.

alter table <tablename> drop column < columnname>;

NARENDRA

• Dec 12th, 2006

 

Alter table TABLENAME drop column COLUMNNAME

Generally rollback cant be followed are implemented along with these DDL statements. The commit statement automatically involves.

sharmasl

 Profile Answers by sharmasl 

• Mar 23rd, 2009

 

use the following syntex for drop the column


alter table emp drop column ename;