Posted by corey lawson on 10/20/05 20:06

Mike wrote:

> I am sort of new to SQL. I use MS-Access most of the time so I do not know
> if you can do this, but...
>
> In MS-Access there was a tool called documenter that would list out the
> table def's such as fields, sizes, data types, etc. Is there such a thing in
> SQL?
>
> I am using MS-SQL 2000 server.
>
> Mike
> m charney at dunlap hospital dot org
>
>

Check out the various INFORMATION_SCHEMA views, i.e., select * from
INFORMATION_SCHEMA.TABLES

[Back to original message]