Solved

Create Data Dictionary for MS SQL Server Database

Posted on 2007-12-05
5
3,958 Views
Last Modified: 2010-04-21
Hi experts:

Does anybody know if MS SQL Server contains a tool to create a Data Dictionary for a database, or if not then is there a good cheap tool that will create a data dictionary on a MS SQL Server database?

Thank you,
P
0
Comment
Question by:pdlarue
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 

Author Comment

by:pdlarue
ID: 20410984
I'm using MS SQL Server Management Sudio Express 2005 to connect to the database on a network over the internet via an IP Address
0
 

Author Comment

by:pdlarue
ID: 20411036
I saw where TRACEYMARY suggested the following SELECT statement but it seems as if 2005 does not like sysproperties.
 
SELECT sysobjects.name AS [Table], syscolumns.name AS [Column], sysproperties.[value] AS Description
FROM (sysobjects INNER JOIN syscolumns
ON syscolumns.id = sysobjects.id) LEFT JOIN sysproperties
ON sysproperties.smallid = syscolumns.colid AND
sysproperties.id = syscolumns.id
where sysobjects.name = 'yourtable'
0
 
LVL 8

Accepted Solution

by:
i2mental earned 125 total points
ID: 20411056
As for Data Dictionary, are you looking for the MetaData for each column? Meaning do you want to be able to type your own description and see it in your dictionary? If so, you may look at SQLDoc from Red Gate. It's cheap and brings up all of that metadata into HTML outputs with the ability to type your own descriptions and have it update the database for you as well.

http://www.red-gate.com/products/SQL_Doc/index.htm
0
 
LVL 8

Assisted Solution

by:i2mental
i2mental earned 125 total points
ID: 20411079
You can also view this via a database diagram depending on how you want your output. With the database in SSMS, right click on data diagrams and create new diagram. Add the tables you want to see. You'll be able to see the relationships between each table amongst other things. You can select which columns and how much detail you want for each table by right clicking on them and selecting custom. Description is a column you can add.
0
 

Author Closing Comment

by:pdlarue
ID: 31455761
Sorry about the delay, i2mental.  I was waiting for more information and now I'm not even working with MS SQL Server.  Thanks for your help though.  Hopefully this will help somebody else.  Thanks again.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question