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

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.

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

alter table <tablename> drop column < columnname>;

Alter table TABLENAME drop column COLUMNNAME

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