pdlarue
asked on
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
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
ASKER
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'
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'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER