sabby

• Nov 23rd, 2005

 

not directly you have to do it like this

create table emp1name,emp_no) as select ename, empno from emp

rama

• Nov 28th, 2005

 

yes.from ora9i

 alter table <tablename>  rename <old col name> to  <new col name>

sunitha

• Dec 2nd, 2005

 

yes definetly,

select ename e_name,empno emp_no from emp;

manju

• Dec 12th, 2005

 

alias names for columns is possible

but changing the column name is not possible

Manohar

• Dec 13th, 2005

 

No.Aliases is

Praveena

• Dec 14th, 2005

 

Yes we can alter Column name in a table using the following query:

alter table <tablename> rename column <old Column Name> to <New Column Name>

Regards,

Praveena

 

 

Shweta Vishwakarma

• Jan 9th, 2006

 

No,we cannot change the column name permanently.

Yes there is one query which changes column name temporarily ie.

alter table <tablename> rename column <old Column Name> to <New Column Name>

This query changes column name temporarily but there is no changes in the original database as such.

Pawan Ahuja

• Mar 7th, 2006

 

We can change the column name of the table

that is available in oracle 9i.

alter table tablename rename column column1 to column2;

rahul

• Mar 23rd, 2006

 

Hi Praveena,

Your query helped in changing the col name of table

Rahul

nileshsingh

 Profile Answers by nileshsingh 

• May 18th, 2006

 

yes,certainly we can change the name of the column in a table.

the query should be:

alter table <table name> rename column <old_column_name> to <new_column_name>

But i have tried this on Oracle 10g,it is not working on Oracle 9i.I dont know why???? pls suggest.

sasi

• May 25th, 2006

 

Alter table <table name> rename column <old column name> to <new column name>

It will work exactly in Oracle 9i.

Oracle Developer

• Jul 11th, 2006

 

Yes. I tried.

alter tablename rename column oldcolumnname to new columnname

is working in Oracle9i.

jojan

• Nov 14th, 2006

 

updated one

alter table <tablename>  rename <old col name> to  <new col name>

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 3rd, 2006

 

Yes you can chage the column name but oracle version must be 9.2 or above.

Trueman Mhango

• Jun 14th, 2007

 

I have tried to change the colunm name with, alter table <tablename> rename colunm <oldcolunm> to <newcolunm>

ravi4ukanth

 Profile Answers by ravi4ukanth 

• Mar 25th, 2008

 

we cannot change or modify the column name in oracle 9i.

chengshun xia

 Profile Answers by chengshun xia 

• Mar 25th, 2008

 

For MS SQL, you can use store procedure sp_rename to rename table ,syntax:

exec sp_rename 'old object name', 'new object name'

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 16th, 2008

 

You have missed out column.
The proper syntax would be:
sql> alter table <tablename> rename column <curren_col_name> <change_name>;

SQL> alter table emp rename column ename to name;

Table altered.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 16th, 2008

 

SQL> alter table emp rename column ename to name;

Table altered.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 16th, 2008

 

We can change the column name.

krishna748

 Profile Answers by krishna748 

• Dec 19th, 2008

 

by using the following command we can rename the column name...

it can be used form  oracle 9i Release2 only...

alter table <tablename> rename <old coluname> to <new col name>

neethana

 Profile Answers by neethana 

• Mar 25th, 2009

 

alter table TABLENAME change OLDNAME NEWNAME (DATATYPE)

ysnkumar

 Profile Answers by ysnkumar Questions by ysnkumar

• Mar 30th, 2009

 

we can change he column name in a table using ALTER TABLE query:

Syn:-

ALTER TABLE TABLE-NAME RENAME COLUMN OLD-COLNAME TO NEW-COLNAME;

EX:

alter table emp reanme column sal to basic;

nari_4881

 Profile Answers by nari_4881 

• May 27th, 2009

 

ALTER TABLE Table_1 ALTER COLUMN test1 nchar(20)

nirrocks

 Profile Answers by nirrocks 

• Apr 19th, 2011

 

yes

alter table table_name Rename column_name to new_name

nirrocks

 Profile Answers by nirrocks 

• Apr 19th, 2011

 

alter table table_name rename column old_column_name to new_column_name;

smartyguys05

 Profile Answers by smartyguys05 

• Apr 28th, 2011

 

alter table table_name rename column oldcolumn to newcolumn;

Santhoshkandula

 Profile Answers by Santhoshkandula 

• May 11th, 2011

 

   yes, it's possible to change the column name by using the following query in SQL server


       SP_RENAME ' <TABLE_NAME.OLD_COLUMN_NAME> ' , ' NEW_COLUMN_NAME '



   Thanks & Regards
    K.Santhosh

dude_8550

 Profile Answers by dude_8550 Questions by dude_8550

• Jun 15th, 2011

 

u can change the column name and also column definition that is whether the data type and its size by the ALTER command.

ALTER TABLE <tablename> RENAME COLUMN <old column name> TO <new coumn name>;