[dba-SQLServer] "Data dictionary"

Mike & Doris Manning mikedorism at adelphia.net
Thu Sep 23 09:37:07 CDT 2004


Hi John,

You can actually do this yourself with no queries involved.  Here is a link
to get you started.

http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=1

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W.
Colby
Sent: Thursday, September 23, 2004 10:09 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] "Data dictionary"


My client wants what he refers to as a data dictionary.  What he is
referring to is a list of all the DISTINCT values in the data for a specific
set of fields.  Is there any (cheap / free) tool that can do this?  I need a
table or spreadsheet, with the field name, then the distinct values in that
field.  I can do this field by field by building queries but if there is
something quick and easy it sure would help.

John W. Colby
www.ColbyConsulting.com 


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list