how can I add a column to show Nulls in my database diagram

[laurasean]

I know how to show the data types, (whether it's an Integer, VarChar, etc.)
but I want the diagram to also display/show which fields permit Nulls. I did
a reverse engineer on my SQL Database. I am going to use my Visio diagram as
a supplement to the company's documentation, so it's important that it has
some way to show which fields allow Nulls in the database. Thanks!

 

[Scot Becker]

I know how to show the data types, (whether it's an Integer, VarChar, etc.)
but I want the diagram to also display/show which fields permit Nulls. I
did
a reverse engineer on my SQL Database. I am going to use my Visio diagram
as
a supplement to the company's documentation, so it's important that it has
some way to show which fields allow Nulls in the database. Thanks!

By default, mandatory columns are bold and nullable columns are not. If you
use the IDEF1x notation, it will append columns names with an "(O)" to
indicate that the column is nullable.

Hope that helps,
Scot.
................................................
Scot Becker

Orthogonal Software
www.orthogonalsoftware.com

ORM Blog: www.objectrolemodeling.com

To e-mail me, please use my first name at the domain listed above. All mail
sent to the reply-to address gets routed to a junk e-mail folder where it
will likely be deleted without being read.