Thursday, May 26, 2011

Alter Table name in oracle

Alter Table name in oracle.
Here I have a table named Employee, I want to name its name from Employee to User. 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 table name. Please see the example.
ALTER TABLE Employee
RENAME to Users;

No comments: