Will the report output just the schema, or are you looking for a
report to make suggestions on things like shortening column lengths
and missing indexes? A place to start would be the INFORMATION_SCHEMA.
All DB's have available many tables like INFORMATION_SCHEMA.COLUMNS.
Lookup in BOL.