GeekInterview.com
Series: Subject:
Question: 104 of 104

How do you remove a column from table

Asked by: Interview Candidate | Asked on: Sep 14th, 2005
Showing Answers 1 - 4 of 4 Answers

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

alter table TABLENAME drop column COLUMNNAME

  
Login to rate this answer.
Abhijit Singh

Answered On : Apr 30th, 2007

View all answers by Abhijit Singh

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

  
Login to rate this answer.
Mohammed Abdul Afroze

Answered On : Sep 27th, 2007

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

Sql>Alter table

drop column .

  
Login to rate this answer.

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 DROP COLUMN

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.