Erwin: propagate comments to multiple tables.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Erwin: propagate comments to multiple tables....

Erwin: propagate comments to multiple tables.

Rate Topic

Display Mode

Topic Options

Author

Message

abell54

Posted Monday, March 01, 2010 3:53 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 11:14 AM
Points: 44, Visits: 159

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

aaron.reese

Posted Wednesday, March 03, 2010 10:51 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:33 AM
Points: 234, Visits: 441

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

cindyj

Posted Thursday, March 04, 2010 10:19 AM

Valued 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 »

Permissions