Thursday, November 18, 2010

Oracle: Rename a column in a table

Oracle provides "alter table" syntax to rename data columns in-place in this form:

ALTER TABLE
table_name
RENAME COLUMN
old_column_name
TO
new_column_name;

Here are the example of Oracle "alter table" syntax to rename data columns:

ALTER TABLE
pick_line
RENAME COLUMN
"VOLUME"
TO
"volume";

No comments: