Repetitive copy of columns to multiple tables
mtefftFeb 28 2012 — edited Feb 28 2012I 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