Column Information

Here's another extremely useful script that lists column information for all tables in a given database. The attached view contains just about anything related to a column definition in SQL Server 2000. The query that you'll see after the view definition contains the following columns.

• Table Name
• Column Name
• Type (and size if applicable)
• Nullability
• Default Value
• Description

There is a lot more information that you can gleam from the view, but the above are the basics that I find really handy.

You can download it here...