A found a great product that produces some nice data dictionary's. There is sql code provided, as well as a document creation tool.
http://www.csvreader.com/posts/data_dictionary.php
I like it quite a bit, it makes it easier to produce a data dictionary for the user to view when requested, and gives the ability to manage descriptions at the database level so generating documentation on-going is easy to do.
