Auto document foreign key descriptions

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

Auto document foreign key descriptions

Postby janie » Thu Feb 25, 2010 1:43 am

Hi,

I have a question.

I have added a description to a column [column a] in a table [table 1]. I have another table [table 2] that has a column [column b] which is a foreign key to [table 1].[column a]. The description that I added in table 1 for column a has not filtered down to either the column description (column b) nor the foreign key description for table 2.

Is this the intended behaviour? Can a feature be added to enable the description for a column in one table be applied to all other tables that reference it?

Just out of interest is there an estimated time frame for the next release?
janie
 
Posts: 1
Joined: Thu Feb 25, 2010 1:29 am

Postby David Atkinson » Thu Feb 25, 2010 1:32 pm

Hmmm... nice idea. So effectively all columns that are linked via a FK relationship would have the same description?

I'd be interested to hear from anyone else who would like this behavior. Are there cases where people would want these descriptions to be different?

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby aculver » Tue Mar 09, 2010 5:07 pm

I would prefer they NOT be the same. In many instances, the documentation (and even the column name) at opposite ends of an FK relationship are quite different.

But there would be value in showing the opposing column name and documentation while editing an FK column, making it easier to refer to the other and allowing cut and paste (which would cover Janie's suggestion too).

Andrew Culver
aculver
 
Posts: 13
Joined: Sun Feb 26, 2006 3:16 am
Location: Montreal


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron