Raname column in Oracle

There is rename column in Oracle 9i Release 2.
For example:
ALTER TABLE staticobject
RENAME COLUMN idobj to id

Can I hope that it will include in VP-functionally?

TIA, Eugeny

Hi Eugeny,

Thanks for your post. Currently you can check the option “Include drop table/columns that not exist in ER model” when update database (see attached image) to update your database (and DDL) for renamed tables/columns. Currently it will drop the renamed table/column and re-create it.

Alter statement for renaming tables/columns is on our to-do list already, but there is no fixed time frame yet. I’ll let you know if there is any further news on this issue.

Best regards,
Lilian Wong