Data Dictionary - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Data Dictionary

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-26 : 08:04:48

Brandy Jack writes "I am looking for somewhere to start to get the data dictionary out of SQL with a generic script that I can run on each SQL Server that will pull all the tables and their comments, all the colunms and their comments.
I know this is possible within the ERwin product, but are there any SQL Scripts already written that can do the same thing?

Thanks for any help you can provide.

Brandy Jack"

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-10-26 : 08:36:40

Check this out:

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73884[/url]

Harsh Athalye
India.
"Nothing is Impossible"

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-10-26 : 23:08:56

I wrote an app that is just the thing for you. It's called sqlspec, link to it is in my sig below. Here's an example output (for a particular table in AdventureWorks):

http://www.elsasoft.org/SUMMER.AdventureWorks/table_HumanResourcesEmployee.htm (IE browsers)
http://www.elsasoft.org/tabular/SUMMER.AdventureWorks/table_HumanResourcesEmployee.htm (non IE, like Firefox, etc)

Incidentally, I also wrote scriptdb.exe, which Harsh pointed you to above. It's more for generating scripts than a real data dictionary.

Hope it helps!

SqlSpec - a fast, cheap, and comprehensive data dictionary generator for
SQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources