asked on

want to see how tables are linked

using sql server 2005 enterprise
is there a tool (graphical preferred) where i can see how tables are connected

http://static.rbytes.net/fullsize_screenshots/s/q/sql-diagrams.jpg

Aneesh

you can create a diagram in sql server management studio
right click on diagrams -> new diagram -> add the tables and it will draw a nice diagram like the one you showed

rgb192

ASKER

in ssms for sql server 2005 enterprise
cant find 'diagram(s)'

Aneesh

you have to explore the yourdatabase on object explorer
see the database diagrams under the selected option in the following picture http://www.pinaldave.com/blogfolder/collation.gif

rgb192

ASKER

this is 'database properties'
cant find 'diagram(s)'

Aneesh

you forgot the attachment

rgb192

ASKER

http://www.pinaldave.com/blogfolder/collation.gif

this is 'database properties'
cant find 'diagram(s)'

Aneesh

just under the selected "Adventure works" you can see "Database Dia"

rgb192

ASKER

clicked 'database diagram'

and got this error

TITLE: Microsoft SQL Server Management Studio
------------------------------

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

------------------------------
BUTTONS:

OK
------------------------------

ASKER CERTIFIED SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rgb192

ASKER

thanks