Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2004-02-19 : 07:15:10
|
| Hi,Is it possible to get a output of all the tables in a database with all the columns on 1 paper? Sort of a birds eye view of all the tables?I can do this manually, but I was wondering if there are any free products out there that do this? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-02-19 : 07:23:18
|
| You can print diagrams in Enterprise Manager, will that do ?Damian |
 |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2004-02-19 : 15:29:39
|
| DOes it compress it all to one page?How do I do that anyhow! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-19 : 15:32:48
|
| Yes you can put them on one page, but the objects would have to be pretty small or your paper would have to be pretty big and printed on a plotter printer if you had a lot of tables. To create a diagram, go to the database in Enterprise Manager. Go to diagram, then right click in the white space on the right pane and click create new diagram.Tara |
|
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2004-02-19 : 16:10:15
|
| Ok I remember trying that before. I just WISH EM would arrange them in a way where it would maximize space on a printout instead of scattering them so wide horizontally! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-19 : 16:54:44
|
| There are other 3rd party tools that can diagram a database better. EM was offered because it's free. ERwin does a much better job and even Vision does a better job, so you might want to look into the other diagramming software that is out there.Tara |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-02-19 : 17:10:47
|
quote:
I just WISH EM would arrange them in a way where it would maximize space on a printout instead of scattering them so wide horizontally!
I don'tI want it to leave them the hell alone so I can spent the 2 - 5 minutes it takes to set it up the way I want it. Stop being so lazy  Damian |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-02-19 : 17:39:06
|
| Right-click and do "show page breaks" so you know where to move things around to.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
Database Tables Overview - printouts?