Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3984
  • Last Modified:

Create Data Dictionary for MS SQL Server Database

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
pdlarue
Asked:
pdlarue
  • 3
  • 2
2 Solutions
 
pdlarueAuthor Commented:
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
 
pdlarueAuthor Commented:
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
 
i2mentalCommented:
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
 
i2mentalCommented:
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
 
pdlarueAuthor Commented:
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now