Visio does an alright job.

>Any 3rd party tools that can document database structure automatically? We have a database from a client that don't have proper documentation and we will be forced to document it.