Creating database diagram

[ecannizzo]

i'm using Visio Professional 2003 version and creating a database diagram. I'm adding all the columns and datatypes using Visio's database properties window. When it creates the shape on the paper it has the PK and Column name, but doesn't show the datatype. How can I add the datatype into my drawing?

Thanks.

 

[GeertVerhoeven]

Hi,

You can set this in the Database\Options\Document menu. In the Table tab you can set how the datatype needs to be shown.

Greetz,

Geert

Geert Verhoeven
Consultant @ Ausy Belgium

My Personal Blog