Posted by sqlmatt on 07/17/07 16:47

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.

• Next in forum: Re: Same query - different execution plans??
• Prev in forum: Re: Trigger After Delete - I would need a Trigger Before Delete
• Thread view: Re: database information report

[Reply to this message]