We all have our favorite database structure generator or schema reporting tool. Maybe
we have built one of them in the past. I always tell my clients that it's
a great "first application" to build when learning SQL
Management Objects (SMO).
I just found out about SqlSpec.
SqlSpec generates documentation in two formats: HTML or CHM. I particularly like the
CHM format, especially when you want a single, compact file containing
all your documentation about one or more databases. The CHM is indexed so it is easily
searchable for any keyword. If you visit their Samples page,
you can see what these CHM files look like.
Naturally, SqlSpec supports SQL Server and Analysis Services, but also other
legacy databases like Oracle, MySQL, and Access. It's $149 and they have a
free trial version.