Alter table add column at a certain position

User_84SZK

Hey,

like I can see, it is possible to generate automatically alter/rename scripts using “Data type conversion” to copy a table to another. This is described in Jeffs blog.

https://www.thatjeffsmith.com/archive/2012/03/diffs-and-alter-scripts-via-oracle-sql-developer-data-modeler/

Is there also a possibility to add columns at a certain position afterwards?

So can data modeler generate an automated script for this or exist a workaround to generate it?

Philip Stoyanov-Oracle

you need to set "Use columns order property" flag

Philip

Dave_VZ

The best answer I can offer is that you look up the ALTER TABLE ADD COLUMN syntax in the SQL Reference Guide. The only method I've used was to add the column(s), commit, then perform a create-table-as-select (CTAS) step to reorder the columns. Hope this helps.

User_84SZK

Hi Dave,

that is right but my question is.

It is possible to generate this from data modeler or not?

Philip Stoyanov-Oracle

you need to set "Use columns order property" flag

Philip