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 |
|
GoDaddy
Yak Posting Veteran
64 Posts |
 Posted - 2009-03-06 : 11:05:21
|
| Is there a nice documentation tool for db?I want to document the database columns description for example, and the extract that into a table in a word document |
|
|
GoDaddy
Yak Posting Veteran
64 Posts |
Posted - 2009-03-06 : 11:09:08
|
| free if possible. Or does MS provide some doc tool ? |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-06 : 12:14:43
|
| Depends on what you mean by "documentation". You can query the INFORMATION_SCHEMA views to get table, column, primary and foreign keys, and other contraint information. See Books Online for details. Column descriptions are extended properties, they're not in INFORMATION_SCHEMA but there's procedures to extract them (if they're defined). |
|
|
|
GoDaddy
Yak Posting Veteran
64 Posts |
Posted - 2009-03-06 : 12:18:31
|
| Basically im just want a tool that will get the info an put it in a table. any tool recommandation? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-06 : 12:47:26
|
| Visio can reverse engineer a database, but it creates a diagram, I don't know if it tabulates the information. I'm sure there's some RedGate tools that can document a database, but they're not free. Visual Studio has an edition that does something similar, again it's not free. |
|
|
|
GoDaddy
Yak Posting Veteran
64 Posts |
Posted - 2009-03-06 : 16:42:54
|
| The visual studio one, is it visual studio team database edition? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-06 : 17:10:10
|
| That's correct. |
|
|
|
|
|
|
Documentation tool