Is there any chance to remove a column of a table

  • Interview Candidate
  • 32
  • 3249

Showing Answers 1 - 32 of 32 Answers

Paramjeet singh

  • Sep 15th, 2005
 

Yes

  Was this answer useful?  Yes

visitor

  • Sep 21st, 2005
 

u can create another table again as

create another_tablename as select reqcolm1,reqcol2 from previous_tablename

and then drop the old table and again

create reqtablename as select * from another_tablename;

and then drop the another_tablename table

u will be having the table content with the column that u want to remove finally

  Was this answer useful?  Yes

Priyaranjan Behera

  • Oct 4th, 2005
 

Hi,

We can remove the column of a table by the following command.

ALTER TABLE <table_name> DROP COLUMN <column_name>

 

Regards,

Priyaranjan

  Was this answer useful?  Yes

Priyaranjan

  • Oct 4th, 2005
 

We can drop a column from a table by following command.

ALTER TABLE <table_name> DROP COLUMN <column_name>

  Was this answer useful?  Yes

ramakumar

  • Dec 14th, 2005
 

yes we can drop the column of table. but the column contains no data.

alter table <table_name> drop column <column_name>;

  Was this answer useful?  Yes

sreelakshmiI

  • Feb 16th, 2006
 

ALTER TABLE <table_name> DROP COLUMN <column_name>

  Was this answer useful?  Yes

Kin

  • Apr 1st, 2006
 

Yes U can use that command only if there is no data

  Was this answer useful?  Yes

oradba

  • Apr 6th, 2006
 

You can user the this command to drop a column even though there IS data in this column.

ALTER

  Was this answer useful?  Yes

oradba

  • Apr 6th, 2006
 

You can user the this command to drop a column even though there IS data in this column.

ALTER TABLE emp DROP COLUMN deptno;

  Was this answer useful?  Yes

Amit

  • Nov 14th, 2006
 

this Alter command is only possible if column we want to drop should be empty,then only it possible.

  Was this answer useful?  Yes

Abhijit Singh

  • Apr 30th, 2007
 

Yes it is possible with queries posted above provided following two requisites

1) The query must be run on Oracle 8i or higher.
2) The column must be empty.

  Was this answer useful?  Yes

selva

  • May 12th, 2007
 

yes, that is possible. we use set unused option in alter statement.
alter table <table.name> set unused column(column.name);

  Was this answer useful?  Yes

kumars77

  • Apr 24th, 2008
 

Yes u can by
alter table <tablename> drop column <column_Name>
it will work whether date resides in this or not deosn't matter

  Was this answer useful?  Yes

peprah

  • Jan 20th, 2010
 

Sure why not?
First of all you need to know and be sure of the table name and column you want to delete. There you are:
 
DELETE FROM [TABLE_NAME]
WHERE [ROW_NAME] = ['COLUMN_NAME'];

 EXAMPLE;

DELETE FROM STUDENTS
WHERE STUDENTID = 'ST001';

In my student table I have a row labelled studentid and a column with ID number of ST001

  Was this answer useful?  Yes

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions