Hiding Columns in ER diagrams in Visio

Subject: Hiding Columns in ER diagrams in Visio
From: Karen Casemier <karen -dot- casemier -at- provia -dot- com>
To: TECHWR-L <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Fri, 12 Sep 2003 13:32:52 -0400

OK, while you all figure out how to say dirty words in Latin, I have a Visio
question.

I'm creating ER diagrams (Visio 2000). I used the Database>Reverse Engineer
function to import all my tables. Due to the nature of this database, we do
not have "true" foreign keys, so I need to manually add the relationships
between the tables.

The problem is that some of the tables have over 100 columns, so it becomes
hard to work with the entity shapes. In the final diagram that is included
in the documentation, only the table name and primary keys are listed for
each entity. What I would like to do is hide the column names in the entity
shape on the diagram, but not remove them from the table itself - I need
them still associated with the table so I can properly set up relationships
between tables. So far, all I've been able to do is remove column names
(using the Remove function on the Columns tab of the Database Properties
dialog). But once I do that - they are gone from the table. ARGH.

Any ideas? Do I make any sense at all? It is a Friday, after all.

Thanks!

Karen Casemier




Previous by Author: Re: ADMIN: Update on junk email problems
Next by Author: XML: Was Refining My "Cutting Edge" Technical Writing Skills Post
Previous by Thread: Re: WAY OT: Help with Latin
Next by Thread: RE: Hiding Columns in ER diagrams in Visio


What this post helpful? Share it with friends and colleagues:


Sponsored Ads