Thursday, May 26, 2011

Alter column name in oracle

Alter column name in oracle.
Here I have a table named Employee, I want to rename column - Name to FullName.
First we can create a table with name Employee.
create table Employee
(
Id int primary key ,
Name varchar2(100)
);


Next we can write the alter table statement to alter the column name. Please see the example.
ALTER TABLE Employee
RENAME COLUMN Name to FullName;

No comments: