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 |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-05-10 : 16:20:49
|
| Is there anything out there that will automatically generate documentation on views, showing all the tables that the view is joining and the columns it is selecting?I have tried Visio 2007, but unfortunately it does allow you to select views above SQL 2000, not sure why.I tried red-gate SQL Doc, but it doesn't show the tables that are used in the views, just generates the SQL for it.thanks. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-05-11 : 00:45:03
|
I wrote a tool called SqlSpec that will do this for you, see the link in my sig.
elsasoft.org |
 |
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-05-11 : 09:35:01
|
| I actually found that right after I posted. Elsasoft seems pretty amazing and even includes a batch file. Thanks! |
|
|
|
|
|
|
auto generated View documentation