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)
- Default Value
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...
Post a Comment