Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Repetitive copy of columns to multiple tables

mtefftFeb 28 2012 — edited Feb 28 2012
I need to add some 'audit columns' such as date/time row created, date/time row last updated, etc. to a large number of tables.

If I was using ERwin, I would generally create these columns in a 'scratch table' in the model, with appropriate datatypes, comments, etc. and I could then copy (via ctrl-drag & drop) to other tables as needed.

Is there a way to accomplish similar copying with SQL Developer Data Modeler? I do not want to open every table, go to column list, click Add for each column, comment it, etc.

Thanks,
Mike
This post has been answered by Philip Stoyanov-Oracle on Feb 28 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2012
Added on Feb 28 2012
3 comments
477 views