Display Options for Physical data Model ERD

[Ed P]

Hi there -

I have the Corporate edition, and I am attempting to create a visual of the physical data model by reverse engineering a SQL Server 2008 R2 database. I imported the tables I wanted via Import DB Schema from ODBC.

When I drag a couple of the tables from the right menu onto the ERD, it displays the tables and their relationship as expected. But I'd like to NOT display the bottom sections of the tables that show the names of the PK and FK constraints along with the tags. I just want to see the upper parts with the table name and the columns/datatypes.  I can't find a way to customize the view this way.

Is there a way for me to do this in Enterprise Architect? If so, how do I go about doing it? Ideally, I'd like to be able to set the default view the way I want it so I don't have to go set it for every entity I drag on the page.

A related question is that when I drag the two tables on the page, I'd like to be able to set the default behavior to not print the labels with constraint names next to the lines. I know I can remove them manually, but that becomes tedious with a lot of tables. Is there a way to change this default behavior?

Thanks!

[KP]

Open the diagram properties dialog (F5), go to the Elements tab and uncheck all the compartments you don't want to see (e.g. Operations).

[Ed P]

Thanks for the answer, that worked! I was also able to get rid of the "<<column>>" header by unchecking Show stereotypes on the Features tab, and removing all the connector labels by checking Suppress all connector labels on the Connectors tab. It now is formatted the way I would like.

After doing this, I just ran into another issue that I can't find anything in the help about. Since I first connected to the database and selected a dozen tables, I have made several changes to the tables directly in the database (this is the way we'll be developing). I'd like to refresh those tables by connecting to the database again and have new columns, relationships, etc, be reflected.  However, when I connect again, it is asking me to re-select tables as if I am starting from scratch. And when I re-select them, it does not update the ones in my project/EAD. How do I synchronize/refresh my objects from the database on a regular basis?

Thanks!