Pete,
If you are willing to pay for something, how about this:
http://www.red-gate.com/products/SQL_Doc/index.htm>Hi All, anyone know a way of listing table defs for every table in a database ? I need to do some documentation and this is my starting point