Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Erwin: propagate comments to multiple tables. Expand / Collapse
Author
Message
Posted Monday, March 1, 2010 3:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 9, 2014 7:32 AM
Points: 44, Visits: 167
I am modeling a database which uses the same column multiple times throughout many tables, ex there is a timestamp field in every table and I’d like to add the comment 'records last modified date' as a comment each time this field is used...any suggestions?
Post #874772
Posted Wednesday, March 3, 2010 10:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:34 AM
Points: 386, Visits: 624
Are you saying that you want a single table that holds

TableName, DateLastModified


If so, then one way would be to add a trigger to every table that you require to be logged to create or update the record in the LastUpdate table.

Post #876183
Posted Thursday, March 4, 2010 10:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, November 30, 2012 10:04 AM
Points: 73, Visits: 2,131
If you are talking about adding comments in ERwin when you add the audit column(s) to a table (or to update comments where the columns already exist), there are a few options:

Copy the column(s) from one table to another (ERwin 7.x). Highlight the column in the table you want to copy from, holding the 'CTRL' key down while dragging it to the new table. The comment will copy with all of the other column info.

Check out this article from InfoAdvisors on how to mass import definitions into ERwin:
http://www.infoadvisors.com/ArticlesVideos/MassImportofDefinitionsinERwin/tabid/159/Default.aspx

You can also use the ERwin API to import definitions. Use your CA site ID to log in and search the knowledge base for the API Reference Guide and presentations on how to use the API.
Post #876971
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse