Adding a default set of Audit Columns for each entity

Toad Data Modeler
1

I’m trying to find a way to add a default set of columns to each enntity for auditing purpose for each entity. I want to automatically generate all the column when the an entity is created.

The set of colums is required for each table in the model below:

Insert_Datm date not null,
Update_Datm date null,
Error_Flag char(1) not null,
Delete_Datm date null,
Source_Key Varchar2 (256) not null

If there’s no way to autogenerate these, is there a way cut/past all colums into the DM at one time?

Thanks

2

By the way, I’m using version 4.3.3.6 of the Toad DM software.

Also note, the model is not static, so new entities will be added over time and I will want to automatically generate these colums for the new tables with duplicating them in the older tables. (This seems to happen when using a Macro)

Hopwfully someone else has discovered a way to do this without some convoluted navigation.

Thanks

3

Hi,

thanks for your feedback. See this article, please:
http://toadworld.com/Blogs/tabid/67/EntryId/994/How-to-add-predefined-columns-to-all-tables.aspx

Regards,

Vaclav

4

I don’t know about this but know i read this so know my knowledge skill is increase i’m very thank full to you & i must share this site to Write Cheap Essay & some my best freinds