Changing column name

How we can change the name of the column for a existing table?

ysnkumar
Profile Answers by ysnkumar Questions by ysnkumar
Feb 5th, 2008
6
2225

Questions by ysnkumar answers by ysnkumar

Showing Answers 1 - 6 of 6 Answers

ravinder.pathania
Profile Answers by ravinder.pathania

Feb 5th, 2008

The coloumn name can be changed by issuing the following command

alter table <tablename>
rename column <oldcolumn> to <new column>

The feature is available after oracle 9i version

ushalakshmi
Profile Answers by ushalakshmi Questions by ushalakshmi

Apr 16th, 2008

The Column Can be changed by using the following command

sp_rename 'Tablename.OldColumnname', 'new columnname', 'COLUMN'
The sp_rename factor and the 'COLUMN' string are required. The TableName factor is the name of the table that the column belongs to. The ColumnName is the current name of the column. The NewColumnName is the desired name you want to give to the column.