RE: SQL2000 Data Dictionary

Subject: RE: SQL2000 Data Dictionary
From: dthomps -at- foundationsoft -dot- com
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Thu, 8 May 2003 10:05:42 -0400

I'm with Andrew on this one. There's no standard format that I know of. I
will add, however, that we're using SQL 7, and we purchased a very cheap
little utility to export all of the information into a Word file. It places
the information for each DB table in a Word table. All I do is apply some
styles, and throw it into our standard template. All in all it takes about
an hour to do ... and that's for a huge DB.

If you're not using SQL 2000 and you're interested in this tool, John, let
me know and I'll get you some info. I can also send you a sample page or

Dannette Thompson
Senior Technical Writer
dthompson -at- foundationsoft -dot- com <mailto:dthomps -at- foundationsoft -dot- com>

Foundation Software, Inc. <>
800-246-0800 ext. 213
The #1 Accounting Software for Labor-Intensive Contractors

-----Original Message-----
From: Andrew Plato [mailto:gilliankitty -at- yahoo -dot- com]

Probably. A data dictionary has no formal design I've ever seen. I used to
them as big tables. The only other column you would want to add is "null?"
indicate if the column can be null or not. Also, you'll want a copy of the
in the dictionary. They are usually sorted by table in the DB, not as a huge
column mass.

I used to doc data dictionaries all the time. SQL 2000 is easy, it will
actually give you a nice export of the entire database. Just reformat that
fill in the rest. I think SQL Server 2000 also has a feature that will doc
database for you. I don't remember. You'd need admin rights to the database
access that feature, which the DBA might not want to give you.

Andrew Plato


Order RoboHelp X3 in May and receive a $100 mail-in rebate, PLUS
free RoboScreenCapture and WebHelp Merge Module.

Order RoboHelp today:

ATTENTION FrameMaker Users: Fill-out the following survey
to receive a chance to win a FREE RoboScreenCapture.

FM users only please:

You are currently subscribed to techwr-l as:
archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit for more resources and info.

Previous by Author: RE: Certification program??????????
Next by Author: Fw: documenting software development lifecycle
Previous by Thread: Re: SQL2000 Data Dictionary
Next by Thread: RE: SQL2000 Data Dictionary

What this post helpful? Share it with friends and colleagues:

Sponsored Ads