Rename column name

[jyaseena]

How can I change the name of the column ? and in big sized database design if I change the name of the column How can we solve this cumbersome task..?

[anwar_s1]

Originally Posted by jyaseena

How can I change the name of the column ? and in big sized database design if I change the name of the column How can we solve this cumbersome task..?

First:


Alter table <tablename>

drop column <columnname>

Second:

Alter table <tablename>
add(<columnname> <datatype>)

[jyaseena]

dear friend

my question is to change the name of COLUMN , not the name of Table..

[cyrus]

You can rename a column in a table as follows:

ALTER TABLE tablename RENAME COLUMN oldcolumn TO newcolumn;

I would suggest that you must be careful and assured while designing the database itself regarding these. Only if it is very essential go for this process now.

[Adrian]

You can also rename by adding a column with a new name and dropping old columns. This can be done as below:

alter table t1 add ( newcolame datatype );
update t1 set newcolname=oldcolname;
alter table t1 drop column oldcolname;

Try as suggested and let us know the result.

[jyaseena]

Originally Posted by cyrus

You can rename a column in a table as follows:

ALTER TABLE tablename RENAME COLUMN oldcolumn TO newcolumn;

I would suggest that you must be careful and assured while designing the database itself regarding these. Only if it is very essential go for this process now.

I used above command but there is error message as below

ORA-14155:Missing partition or SUBPARTITION keyword

[jyaseena]

Originally Posted by jyaseena

I used above command but there is error message as below

ORA-14155:Missing partition or SUBPARTITION keyword

no one to help me please....!!!!