Alter Table Oracle Rename Column

Let s look at an example that shows how to rename a column in an oracle table using the alter table statement.

Alter table oracle rename column. Alter table customers rename column customer name to cname. To rename a column in an existing table the oracle alter table syntax is. Alter table table name drop column. Oracle allows you rename existing columns in a table.

To rename a column in oracle we have to use rename column statement. Please check the below article to learn about these in details. Alter table cust table rename column cust sex to cust gender. The rename column statement allows us to rename an existing column in an existing table in any schema except the schema sys.

Lets see this example. Use the rename column clause of the alter table statement to rename a column. Here are some examples of oracle alter table syntax to rename data columns. Alter table table name rename column old column name to new column name.

Use the rename column clause of the alter table statement to rename a column i e alter table rename column in oracle. Sql desc dept master. You have to use rename column statement along with alter table statement. Sql create table dept master dept nr number unique dept name varchar2 100 not null dept status number 1 0 not null created at date.

Alter table table name rename column old column name to new column name. Rename and modify a column using alter table statement. Alter table table name rename column old name to new name. In oracle9ir2 oracle provides alter table syntax to rename data columns in place in this form.

Alter table rename column in oracle table query oracle rename column table syntax.