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