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:
Post a Comment