SQL - Rename a Column

GeekInterview.com > Tech FAQs > SQL

Go To First | Previous Question | Next Question

SQL | Question 182 of 190

Rename a Column

How to rename a column in a SQL table?

Total Answers and Comments: 10

Last Update: November 03, 2008 Asked by: vimalkumarrai

Sponsored Links

Best Rated Answer

—

Submitted by: sravee123

ALTER TABLE table_name RENAME COLUMN old_name to new_name;

Ex: ALTER TABLE employee RENAME COLUMN eno to empno;

Above answer was rated as good by the following members:
krishnaveni_g

June 10, 2008 00:19:37

sravee123

Member Since: May 2008 Contribution: 18

RE: Rename a Column

ALTER TABLE table_name RENAME COLUMN old_name to new_name;

Ex: ALTER TABLE employee RENAME COLUMN eno to empno;

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

June 10, 2008 02:18:50

nandk.sharma

Member Since: June 2008 Contribution: 10

RE: Rename a Column

ALTER TABLE TABLE_NAME RENAME COLUMN OLD_NAME TO NEW_NAME;

alter table table_name rename

column old_name to

Is this answer useful? Yes | No

0 1

Overall Rating: -1

June 20, 2008 06:56:36

krishnaindia2007

Member Since: September 2007 Contribution: 870

RE: Rename a Column

ALTER TABLE TABLENAME RENAME COLUMN OLDCOLUMNNAME TO NEWCOLUMNNAME

[CODE]
SQL> DESC EMP;
Name                            Null?    Type
------------------------------- -------- ----
EMPNO                           NOT NULL NUMBER(4)
ENAME                                    VARCHAR2(10)
JOB                                      VARCHAR2(9)
MGR                                      NUMBER(4)
HIREDATE                                 DATE
SAL                                      NUMBER(7,2)
COMM                                     NUMBER(7,2)
DEPTNO                                   NUMBER(2)

SQL> ALTER TABLE EMP RENAME COLUMN HIREDATE TO JOINDATE;

Table altered.

SQL> DESC EMP
Name                            Null?    Type
------------------------------- -------- ----
EMPNO                           NOT NULL NUMBER(4)
ENAME                                    VARCHAR2(10)
JOB                                      VARCHAR2(9)
MGR                                      NUMBER(4)
JOINDATE                                 DATE
SAL                                      NUMBER(7,2)
COMM                                     NUMBER(7,2)
DEPTNO                                   NUMBER(2)
[/CODE]

Is this answer useful? Yes | No

0 2

Overall Rating: -2

July 06, 2008 12:48:46

krishna9231

Member Since: June 2008 Contribution: 2

RE: Rename a Column

In ORACLE 9i ,no OPTION FOR CHANGING COLUMN NAME.If you want dispaly as like column nameeg: select empno,ename "EMPLOYEE NAME" from emp;regardskrishna

Is this answer useful? Yes | No

July 07, 2008 02:19:32

sparun1607

Member Since: February 2007 Contribution: 1

RE: Rename a Column

In 0racle 9i Second Realease there is an option for renaming a column.

Is this answer useful? Yes | No

August 12, 2008 00:09:58

janaraj

Member Since: August 2008 Contribution: 7

RE: Rename a Column

For ex..

Select name emp_name from student

Is this answer useful? Yes | No

August 27, 2008 07:46:42

kunal066

Member Since: August 2008 Contribution: 4

RE: Rename a Column

ALTER TABLE test RENAME COLUMN col1 TO id;

Is this answer useful? Yes | No

September 01, 2008 04:36:48

raghuprasad

Member Since: August 2007 Contribution: 23

RE: Rename a Column

We can rename the column name of the table using ALTER TABLE statement.

Eg: ALTER TABLE table_name MODIFY(column_name datatype);

Is this answer useful? Yes | No

0 1

Overall Rating: -1

September 18, 2008 08:14:38

vishnu vardhan reddy

Member Since: September 2008 Contribution: 6

RE: Rename a Column

we can not change the name of the column in oracle once defined.
if the column contains null only datatype,widtth we can change
pls recognise this

Is this answer useful? Yes | No

November 03, 2008 10:11:52

#10

shriraam

Member Since: November 2008 Contribution: 1

RE: Rename a Column

Basically you dont have an option or a separate syntax for renaming a column in 9i, 10g.
But there is one such thing called column alias process can be done initially at the time of querying.

Is this answer useful? Yes | No

Go To Top