CODEWITHSUNDEEP
sql-serverssms
leora
leora

Reputation: 196861

organize sql server enterprise manager DB Diagram view

As i get more and more tables, using the diagram view becomes harder and harder. is there anyway to have it auto order or sort to align joined tables, etc and avoid having to do it manually

Upvotes: 0

Views: 814

Answers (2)

Cory
Cory

Reputation: 12789

In the diagram view, right click on an empty white space and click arrange tables.

alt text http://img706.imageshack.us/img706/3193/71022491.png

Upvotes: 3

Randy Minder
Randy Minder

Reputation: 48522

As you get more and more tables, attempting to have a single diagram that shows your entire database becomes almost pointless. We've got multiple diagrams that show functional areas of our application(s). Such as Work in Process, Process History, Security etc. This is much more useful to us.

Randy

Upvotes: 2

Related Questions