vishalsharma

 Profile Answers by vishalsharma Questions by vishalsharma

• Mar 25th, 2006

 

yes there is a chance to remove column from a tabel you can do that this way

alter table TABLENAME drop column COLUMNNAME

Abhijit Singh

 Profile Answers by Abhijit Singh 

• Apr 30th, 2007

 

The answer posted above works absolutely fine only if it is run on Oracle 8i or higher versions.

Mohammed Abdul Afroze

• Sep 27th, 2007

 

To drop a Column from a Table.The command is.

Sql>Alter table <table name>drop column <column name>.

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 25th, 2007

 

You can remove a column but first of all you should see that column doest have any values and it should not be a primary key

ALTER TABLE <TABLENAME> DROP COLUMN <COLUMNNAME>